Select Page

10 Awesome Excel Tips: Auto Total Is Your Friend!

by | Sep 25, 2022 | Excel Tips, Walkthroughs / Tutorials | 0 comments

Let’s imagine you have a column of values in your spreadsheet and you need to easily calculate the total of all those values, aka figure out the sum. Auto Total is what you need!

In order to use Auto Total, what you can do is, select all your values in the column and add an extra cell at the bottom.

10 Awesome Excel Tips: Auto Total Is Your Friend!

Next, on your keyboard hold down the ‘alt’ key and press the equal ‘=’ sign.

Go to the bottom, to our extra cell. And you see it automatically created the sum formula for all your rows here. This is the total for all the values in this column.

This will also work if you need the total of a row of values.

Again, we select all our cells we want to calculate. Add an extra cell at the end.

Hold down ‘alt’, press equal ‘=’ and there’s the formula.

If you need help with your Excel spreadsheets, I’m Peter Koebel the owner of Data Sciencing Consultants. You can reach me at 204-770-6437, or email me at, or fill out the form on our website  You can also check out our YouTube channel for more awesome Excel tips!

For more Awesome Excel Tips, like this one about “select all cells in a direction”, check out the Datasciencing Consultants blog.

Looking for more fun with data? You might enjoy some of our other posts!

US Population Density Map using Tableau Join our founder, Peter Koebel as he demonstrates a population density map using Tableau. You've probably seen population density visualizations everywhere, but how can you use them in your own...

Datasciencing Customer Demographics with Power BI Join our founder, Peter Koebel, as he walks through datasciencing customer demographics with Power BI. Datasciencing can be tough, but does it have to be? Check out this demonstration...