I just picked up a quick way to quickly total a large set of numbers in Excel 2007/2010 and I wanted to share it with you. With this tip you select the data and then press the Alt Key and then the equal sign key.
Below is a simple table of data.
Simply select from A3 to F9 and then press the Alt key and the Equal sign.
Alt+=
This will automatically total Column F and Row 9.
It is pretty flexible - I get the same result if I select A4 to F9 or B4 to F9.
Have a great weekend.
If you are looking for more great tips check out my Tools and Tips CPE course for Accountants.
http://www.cpaselfstudy.com/item_115/Excel-Tools-Tips-for-the-Accountant.htm
No comments:
Post a Comment