Microsoft Excel Logo

Tables in Microsoft Excel provide many benefits for working with your data. And if your table contains figures that you’d like to total at the bottom, this is a simple task. Here are three ways to add a total row to a table in Excel.

Insert a Total Row Using Table Design

You can add a total row to the bottom of your table using a simple checkbox.

Select any cell in your table and go to the Table Design tab that displays. In the Table Style Options section of the ribbon, check the box for Total Row.

On the Table Design tab, check Total Row

You’ll likely see only one total display, which is currently how the Total Row feature works. But in a few clicks, you can fill in the rest.

Total row inserted

Advertisement

The total row at the bottom provides you with a drop-down list of options for each column. Click that arrow and choose “SUM” for one of the columns.

Select SUM in the drop-down list

Note: If you look at the formula bar, you’ll see that the formula added is actually the SUBTOTAL function. This is a Structured Reference formula that’s solely for tables in Excel.

Then, select the cell and place your cursor on the bottom-right corner to display the fill handle (plus sign). Drag to the remaining cells in that total row to copy the formula.

Drag the fill handle to copy the formula

RELATED: How to Automatically Fill Sequential Data into Excel with the Fill Handle

If you prefer, you can also click the drop-down arrow in each cell and select “SUM” rather than copying the formula.

You should then see the totals for all columns in your Excel table.

Total row inserted in Excel table

Insert a Total Row Using a Keyboard Shortcut

If you’re a fan of using keyboard shortcuts to perform tasks quickly, then this method is for you.

Select any cell in your table and press Ctrl+Shift+T. And there you go! A total row is added to the bottom of your table.

Total row inserted

Luckily, this keyboard shortcut works the same way as the Total Row checkbox on the Table Design tab above, so you can follow the same steps to insert the remaining totals and copy the formula to the other cells in the total row.

RELATED: All the Best Microsoft Excel Keyboard Shortcuts

Insert a Total Row by Adding a Row and Formula

One more way to easily insert a total row in your table is by adding a row, using the SUM formula, and copying it across.

Advertisement

You can quickly add a row to the bottom of your table by going to the last cell in the first column and typing. For instance, you can type in the word Totals and hit Enter, which automatically creates a new table row.

Add row for totals in Excel table

Next, select the cell to the right to insert your first total. Go to the Home tab and click “Sum” in the Editing section of the ribbon.

On the Home tab, click Sum

Now that you have the total for the first column, you can copy that formula to the other cells.

Select the cell with the SUM formula, place your cursor on the bottom-right corner to display the fill handle, and then drag to the remaining cells in that total row.

Drag the fill handle to copy the formula and view your total row

Advertisement

That’s all there is to it! From there, you can format the total row to make it stand out if you like.

Totaling figures in a spreadsheet is a basic function, so having three simple ways to add a total row lets you use the method that’s most comfortable for you.

RELATED: How to Create Expense and Income Spreadsheets in Microsoft Excel

Sandy Writtenhouse Sandy Writtenhouse
With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage.
Read Full Bio »

The above article may contain affiliate links, which help support How-To Geek.