Friday, February 11, 2011

Excel Tip: Use AutoCalculate to get a quick total!


Do you need a total in a hurry but don’t want to bother with a function? Click and drag to select (highlight) the cells you wish to include in the total. Look at the status bar (bottom Window frame) to see the Sum, Average, Count, etc.












If the cells are not adjacent to one another, hold down the CTRL key while you select the cells.


Need other functions instead? Right click on the status bar to see a menu of other commands available.



- Irene Heckert, Microsoft Office Expert; CTT, MCAS, ITIL Certified, MOS LinkIn with Irene

Bookmark and Share

No comments:

Post a Comment