Excel Tip - Autosum Shortcut

We all know about the incredibly useful AutoSum tool on the Home ribbon, but did you know you can also add up a column or row by using a keyboard shortcut...


  • Open a sheet that contains numbers to be totalled up, arranged in either columns or rows:


  • Click in an empty cell under the figures to be added or in an empty cell to the right of the figures to be totalled


  • On the keyboard, press ALT = the Sum formulae will be entered:


  • The Autosum function should automatically select the figures above or to the left to total


  • Press Return to see the total


By using the ALT = keyboard method of entering the Sum function it should speed up the most common type of calculation in Excel.

Pin it