Back to top

Microsoft Excel Tip: Get your total by going formula free

Image
Spreadsheet on Computer
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.
Image
Excel Autosum Shortcut Example