Add and format tables

Add a Total row to a table

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Discover more Excel training at LinkedIn Learning

You can add totals to a table by selecting the Total Row checkbox on the Design tab. You can also add a function from the total row drop-down.

  1. Select a cell in a table.

  2. Select Design > Total Row.

  3. The Total row is added to the bottom of the table.

    Note: To add a new row, uncheck the Total Row checkbox, add the row, and then recheck the Total Row checkbox.

  4. From the total row drop-down, you can select a function, like Average, Count, Count Numbers, Max, Min, Sum, StdDev, Var, and more.

Want more?

Discover more courses like this at LinkedIn Learning

Insert a total row

Basic tasks in Excel 2016 for Windows

A couple other features here available on the Design tab as well.

We can add a Total row. This is gonna be on the bottom.

And right away you might be thinking, well, what happens if we wanna add a new record?

So I've got a total here on the right, and that, by choosing the down arrow, could be an average.

It could be a max or a min. I think total, a sum here makes sense.

Well, we could also take that information and drag it left-ward, possibly into these columns here.

Now, we probably want a total there, but for job rating I'd probably want an average.

So I'll click the drop arrow, choose Average. Average job rating.

And we could add a decimal there if we wanted to. For the moment, don't worry about that.

So the question comes up, what happens if we want to add a new record?

Turn off the Total row, we'll put in a new name out here.

Fill in the other data maybe an hour later, but then go back to the Design tab and simply bring back the Total row.

And if we've added some numbers here, they would be included in the new total.

So these are automatically set up.

You might wanna work with a total row.

Makes it handy to get to that data there.

Learning doesn't stop here. Discover more expert led tutorials at LinkedIn Learning. Start your free trial today, at

Enjoy one month of free access to LinkedIn Learning

Learn from recognized industry experts, and get the business, tech, and creative skills that are most in demand.


  • Get unlimited access to over 4,000 video courses.

  • Receive personal recommendations based on your LinkedIn profile.

  • Stream courses from your computer or mobile device.

  • Take courses for every level – beginner to advanced.

  • Practice while you learn with quizzes, exercise files, and coding windows.

  • Choose a plan for yourself or your entire team.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.