Using AutoSum in Tables
March 14, 2018 - by Bill Jelen

Direct from the Excel development team, Project Manager Ash Sharma shares another of his seven favorite tips about Excel. This is one that I never knew.
Say that you have a boring Excel table like this.

Make the data a table by selecting one cell and pressing Ctrl + T. You will get some nice formatting.

In the Table Tools Design tab, choose Total Row.

Here is the part that I never discovered. To the right of the Total is an INVISIBLE drop-down arrow. You can't see it. But when you click *where it should be*, the drop-down opens! Click here.

Once you click on the invisible arrow, you can change the calculation. Plus, once you've activated the arrow, it will stay visible.
f
This is an awesome trick that took me 10+ years to discover! I am glad that Ash called this out as one of his seven favorites.
I love to ask the Excel team for their favorite features. Each Wednesday, I will share one of their answers.
Excel Thought Of the Day
I've asked my Excel Master friends for their advice about Excel. Today's thought to ponder:
"Don't center-align numerical data."
Title Photo: Eder Sampaio / Unsplash