Create Excel Grand Totals With One Click

I hope you had a wonderful Christmas, and with any luck, you're taking this entire week off. You might still be full of turkey and eggnog, so I'll just give you a small Excel tip today – something that's easy to digest.

Create Quick Excel Grand Totals

Instead of entering each SUM function individually, you can use the AutoSum feature to create all the grand totals with one click.

  1. Select all the cells with numbers, and the blank cells below and to the right, where you want the grand totals
  2. On the Excel Ribbon, click the Home tab
  3. Click the AutoSum button, to insert the Grand totals.

The SUM function is added to each grand total cell, to sum the cells above, or to the left.

Watch the Video

Watch this short Excel video tutorial to see the steps for creating Grand Totals in Excel with one click.


P.S.: For more Excel SUM tips visit the Contexture Excel SUM Functions page.


You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *