January 31, 2017
Hi fellow Excel Addict,
In today's 'Excel in Seconds' tip, I'm going to reveal 'Secrets of the AutoSum Function'.
If you missed my last 'Excel in Minutes' tip, 'Custom Formatting for Your Headers and Footers', you can read it here now.
Please feel free to share my newsletter with your Excel friends — they will thank you for it.
Hope you're having a great week and keep on Excelling,
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
Secrets of the AutoSum Function
Every Excel user knows how to use the SUM function to total to a row or column of numbers.
You simply type =SUM into a cell, or use the keyboard shortcut ALT+= or click the AutoSum (Σ) command found on the righthand side of the Home tab.
When you are not on the Home tab, the AutoSum command is not visible, so if you're really smart, you will have added the AutoSum command to your Quick Access Toolbar so it's always easily accessible.
What you may not have noticed is that the AutoSum command on the Home tab has a small dropdown arrow next to it. Click on it and you will discover that, in addition to SUM, you also have a choice of using the AVERAGE, COUNT NUMS, MAX or MIN functions in the same way. Click the small dropdown, the click the function you want to use.
Alternatively, if you prefer using keyboard shortcuts, pressing ALT then H activates the Home tab, press U to reveal the AutoSum options and then press shortcut key (S, A, C, M, I, F) for whichever function you want to use.
Excel will suggest a range to use, the same ways as with the SUM function, press Enter to accept or drag to select a different range.
If you click the More functions... option, it will open the Insert Function dialog.
If you've found this tip helpful, please click here to share it.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630