Learn › Excel › Sum a column (AutoSum)

Excel AutoSum shortcut: Alt + =

Add up the numbers above or beside a cell with one key combination.

← All Excel shortcuts

With voice. Recorded in Excel for the web; the shortcut works the same in desktop Excel. Recorded on a US keyboard. On other keyboards some keys differ: see the table below the video.

WindowsAlt+=
Mac⌘+Shift+T

Keys on keyboards of other languages

The video is recorded on an English (US) keyboard. This is how the same shortcut is pressed on the keyboards of the other languages. The highlighted row is your language.

English (US)Alt+=
HrvatskiAlt+Shift+0
DeutschAlt+Umschalt+0 *
EspañolAlt+Shift+0 *
FrançaisAlt+=
PortuguêsAlt+= *
ItalianoAlt+Shift+0 *
TürkçeAlt+Shift+0 *
Bahasa IndonesiaAlt+=
PolskiAlt+=

* Based on the keyboard layout, not tested on a real keyboard (only the Croatian one was tested). If the shortcut does not work, use the matching button on the ribbon.

What it does

Alt + = writes a SUM formula in the active cell and guesses the range of numbers above it, or to its left. Press Enter and the total appears.

When to use it

Use it under a column of prices, hours or costs, or at the end of a row. It is faster than typing =SUM( and selecting the cells with the mouse.

How to do it

  1. Click the empty cell right under your numbers (or right of them).
  2. Press Alt + = (on a Mac: Command + Shift + T).
  3. Check that Excel picked the right range, then press Enter.
Good to know: The numbers must be in one block with no empty cell in between, and the cell you click must be directly under (or beside) them. If Excel picks too little, fix the range in the formula before you press Enter.

A quick example

You have costs in B2 to B6. Click B7, press Alt + =, and Excel writes =SUM(B2:B6) and outlines the numbers. Press Enter and the total appears. If you change a number later, the total updates by itself.

AutoSum, SUM and the Σ button

Alt + = does the same as the Σ (AutoSum) button on the Home tab, only without the mouse. The result is an ordinary SUM formula, so you can edit it like any other. The arrow next to the Σ button also offers Average, Count, Max and Min.

Not working? Check this

  • Nothing happens: click into the sheet first, not into the formula bar or a search box, and select one empty cell.
  • On a Mac use Command + Shift + T.
  • Wrong range: an empty cell or text above the numbers stops the guess. Drag the highlighted range to the right cells, or select the cells first and then press the shortcut.
  • The result is 0: the numbers are stored as text (left-aligned). Convert them to numbers first.

Quick answers

What is the shortcut for sum in Excel?

Press Alt + = in the cell under your numbers, then press Enter. On a Mac use Command + Shift + T.

Why does AutoSum pick the wrong cells?

Excel stops at the first empty cell or text above the block of numbers. Click the formula, drag the highlighted range to the right cells and press Enter.

Why is my AutoSum 0?

The numbers are probably text. Numbers that sit on the left of the cell are text, so convert them to numbers first.

← All Excel shortcuts

Chrome extensions

Free web tools

Free games