"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Excel Users Become Local Spreadsheet Experts"

How To Enter Multiple Sum Formulas In One Step


You have multiple columns of data which you need to add totals to.

If you're like most Excel users, you probably use AutoSum to create the total for your first column, then copy that formula and paste it to the remaining columns. There, that was easy wasn't it.

But did you know there was a much faster way to do the same task?

First, highlight all of the cells where you want your totals to go. Then, click the AutoSum button and ,presto, you have created all of your totals in one click.

Think that was cool?

OK, let's assume you have a block of data which you need totals for both columns and rows. Highlight the whole block of data but extend the area you have selected to include the first blank row below your data and the first blank column to the right of your data. Now, click the AutoSum button.

Just like magic, you have totals for both your columns and rows in one step.


Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.