![]() And there you go! A total row is added to the bottom of your table. Select any cell in your table and press Ctrl+Shift+T. If you’re a fan of using keyboard shortcuts to perform tasks quickly, then this method is for you. Insert a Total Row Using a Keyboard Shortcut You should then see the totals for all columns in your Excel table. If you prefer, you can also click the drop-down arrow in each cell and select “SUM” rather than copying the formula. RELATED: How to Automatically Fill Sequential Data into Excel with the Fill Handle Drag to the remaining cells in that total row to copy the formula. Then, select the cell and place your cursor on the bottom-right corner to display the fill handle (plus sign). This is a Structured Reference formula that’s solely for tables in Excel. Note: If you look at the formula bar, you’ll see that the formula added is actually the SUBTOTAL function. ![]() ![]() Click that arrow and choose “SUM” for one of the columns. The total row at the bottom provides you with a drop-down list of options for each column.
0 Comments
Leave a Reply. |