LostInTechnology

How to Quickly Sum Columns in Microsoft Excel 2007 Using AutoSum

Posted on 09. Jun, 2008 by Kyle Judkins in How To, MS Office

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.

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

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

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

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.

Related Posts

• Top 5 Free Microsoft Excel Add Plugins
• Excel Keyboard Shortcut Tip: How to Quickly Highlight Large Tables
• How to Change the Default Settings in Microsoft Word 2007
• Use Track Changes for Group Editing in Microsoft Word 2007
• How to Schedule a Meeting Using Microsoft Outlook

Tags: 2007, autosum, Excel, microsoft, tips, tricks