The AutoSum guide
Click the cell under a column of numbers and press Alt+= (⌘⇧T in Excel for Mac). Excel writes =SUM( with the numbers above already filled in. Check the range before you press Enter.
What AutoSum guesses
AutoSum looks up from the active cell for numbers, and if there are none, to the left. It takes the unbroken run it finds and stops at the first gap or piece of text. The guess is shown with a moving border and stays live: drag over other cells to replace it, then press Enter.
The year in the header
A column titled 2025 has a number for a header. AutoSum can't tell a year from a cost, so its guess runs up to row 1 and the total comes out 2,025 too high. Whenever the header is a year, a date or an ID, look at the range before pressing Enter and drag over just the values.
Several totals at once
Select the numbers of several columns and the empty row under them, then press the shortcut once: Excel puts a total under every column, each with its own range. Selecting only the values, without the header, also avoids the year trap.
On a Mac
Microsoft lists ⌘⇧T for AutoSum in Excel for Mac. In a browser that combination reopens the last closed tab, and the page never sees it, so this practice sheet uses the Σ AutoSum button on the Home tab (it also takes ⌥=, which isn't an Excel for Mac shortcut). In Excel itself the shortcut works.
More than SUM
The arrow next to Σ AutoSum offers Average, Count Numbers, Max and Min with the same guess. The formula is a plain SUM: you can always type it yourself.
FAQ
- What is the AutoSum shortcut in Excel?
- Alt+= on Windows. In Excel for Mac it is Command+Shift+T. Press Enter afterwards to keep the formula.
- Why does AutoSum include the header in the total?
- The header is a number, such as a year. AutoSum adds every number above the cell up to the first gap or text. Drag over just the values before pressing Enter.
- How do I AutoSum several columns at once?
- Select the numbers and the empty row below them, then press Alt+=. Excel writes a SUM under each column.
- Why doesn't AutoSum pick up all my numbers?
- There is a blank cell or a number stored as text in the column, and AutoSum stops there. Drag over the full range before pressing Enter.



































































