Alt+= : Auto-Sum Below a Column

SUM is probably the most-used formula in Excel — you're adding up revenue, expenses, hours, unit counts. Instead of typing it out by hand and double-checking the cell range, Excel has a dedicated shortcut for auto-sum. Just put the cursor below a column of numbers, press Alt+equals, and Excel proposes the range and the SUM formula itself.

A typical scenario

Markéta is closing out the team's monthly expense summary — she needs a total below a column of thirty line items. Without the shortcut she'd have to type =SUM(, select the range manually with the mouse or type it out, close the parenthesis, and hope she didn't select one row too few or too many.

With Alt+= she just clicks the cell below the column, presses the shortcut, and Excel figures out on its own where the column of numbers starts and ends, proposing the range directly — Markéta just confirms with Enter. The formula is done in two seconds, and the risk of a badly selected range practically disappears.

How to do it

1. Click an empty cell below a column of numbers (or to the right of a row of numbers) — wherever the total should go.
2. Press Alt + = (on Mac, Cmd + Shift + T).
3. Excel automatically detects the contiguous block of numbers above (or to the left of) the cell and proposes a matching range in a SUM formula.
4. Check the proposed range in the cell — if it's right, confirm with Enter; if not, drag to adjust the range with the mouse and then confirm.
5. You can use the same shortcut on multiple cells at once — select the empty cells at the end of each column or row (typically a whole row of totals below a table) and Alt+= fills in the sum for all of them at once.

The best tools

• The built-in Alt+= shortcut (Excel) — the fastest way to a total, works in every current version.
• The AutoSum button (Σ) on the Home tab — the same feature by mouse, for anyone who prefers clicking.
• Google Sheets — offers the same feature via Alt+Shift+=; same idea, just a different key combo.
• The status bar at the bottom (select cells with the mouse) — for a quick check of a total without writing a formula, handy when you don't need to save the result anywhere.

What you get out of it

• Time: a few seconds instead of typing a formula by hand and guessing at the range — in larger workbooks with dozens of totals, that adds up to real minutes.
• Accuracy: Excel looks at the cells that are actually filled in, so the risk of a total “cutting off” the last row is lower than typing the range by hand.
• Less to remember: you don't need to remember the exact syntax of the SUM formula — Excel builds it correctly for you.

Pro tip

The shortcut works on several spots at once — select an entire column of numbers, including the empty cell below it, and press Alt+=; Excel fills in the total right at the end without you needing to click into the cell separately first.