Summing It Up With Two Keys in MS Excel

• by Carol Bratt on 20080519 @ 09:53PM EST | google it | send to friends
• Filed under Carol's Corner Office | (related terms: sum, cell, data, autosum, column)

Most of you are familiar with the AutoSum feature in MS Excel and find it very handy indeed. All you have to do is click that icon on your toolbar and bingo! your formula for the sum of a data range is located just above whatever cell you have selected.

I know that there are lots of folks out there like me who prefer to use the keyboard as much as they can because we like fewer keystrokes and saving time! So if you are one of those folks, here is another quick and easy way to sum in MS Excel.

Select the cell below your column of data   Then simply click ALT + = (Alt, plus the equal sign).

Ta-da! The formula needed to sum up the column of data is inserted with the cell references in place, just as if you had clicked the Autosum icon on your toolbar.

When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

Free eBook: Windows 7 - The Pocket Guide. Windows 7 is by far the most favorite and widely-used Microsoft operating system to date, and, there are literally thousands of customizations you can apply to it. This pocket guide will help you customize your Windows 7 PC and make it work in the easiest and most optimized way possible. The eBook is written in an easy to understand manner, whether you're a newbie or seasoned pro user. Click here to download this eBook now! Note: this eBook is free, but registration is required; after that, you can select more ebooks and videos for download without registering again. If you have questions / problems with the registration form, please read this.

---