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.

You can add totals to a table by selecting the Total Row checkbox.

  1. Select a cell in a table.

  2. Select Design > Total Row.
    TotalRow

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

    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.
    functions

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 linkedin.com/learning.

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.

Benefits
  • 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.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×