Microsoft Excel Tip: Get your total by going formula free

Hands working on a Spreadsheet on a Computer from looking above
October 11, 2018

Here's a handy tip for tables:

Add a Total Row without writing a formula.

  1. Click on a cell below a column or row of numbers.
  2. Press Alt + =
  3. Excel will highlight the numbers it is totaling, and fill the cell with the total.
Excel Autosum Shortcut Example