Home » How To » How to Quickly Sum Columns in Microsoft Excel 2007 Using AutoSum

How to Quickly Sum Columns in Microsoft Excel 2007 Using AutoSum

One of the great things about Microsoft Excel is the fact that there are always multiple ways to do just about everything. Today, I’m going to show you a shortcut you can use to quickly sum columns in Excel.

First, you want to make sure that your column of numbers has no blank spaces in it. The blank spaces will throw off the shortcut.

autosum excel autosum excel
Now, click on the cell below the last number in the column.

excel highlighted cell autosum excel
Once this cell is highlighted, you need to click the AutoSum button on the very right side of the Home ribbon in Excel.

excel autosum button autosum excel
This will automatically put in the equation to sum the column. All you need to do now is hit enter.

excel after autosum autosum excel
The AutoSum button can also be used to automatically find the average, min, max, or count of the column of numbers. Just open up the drop down menu on the AutoSum button and pick the one you need.

excel autosum drop down autosum excel

Check Also

reasons for not making money blogging

3 Ways to Destroy Your Company’s Social Media Profile

3 Ways to Destroy Your Company’s Social Media Profile Being put in charge of managing ...

CPA Marketing

Why CPA Marketing is Better than Affiliate Marketing?

CPA stands for cost per action. CPA marketing is similar to affiliate marketing, but is ...

freelance professionals

Professional Environment for Hard-Working Freelance Professionals

The growth of the freelance market is undeniable, since in the USA alone the number ...

Get updated with all the tips, tricks and hack of latest technologies. We discuss technology, programs, tricks, tips, software, windows, internet tools, guides, howto.
Don't miss the latest news from LostInTechnology.com.
Signup today for free and be the first to get the latest news.