Home › Excel shortcuts

AutoSum shortcut

Select the empty cell under a column of numbers and press Alt+=. Excel writes the SUM formula and guesses the range; press Enter to accept it. On a Mac the shortcut is Cmd+Shift+T, which browsers use to reopen a tab, so this page only simulates it on Windows keys.

Try it: press the keys on this sheet

Windows and Mac keys

ActionWindowsMac
AutoSumAlt+=⌘⇧T
Fill downCtrl+D⌘D or ⌃D
Toggle absolute reference ($)F4⌘T or F4
Show formulasCtrl+`⌃`

Shortcut not working?

AutoSum picks the wrong range

It stops at the first blank or text cell. Drag to select the right range before pressing Enter, or select the numbers plus the empty cell first and then press Alt+=.

Alt+= types an equals sign

Press both keys together, not one after the other. On some laptops the right-hand Alt is AltGr and won't work; use the left Alt.

The total shows 0

The numbers are probably stored as text. Look for green triangles in the corners and convert them with Text to Columns or VALUE.

Practise these and 30 more: play the shortcut trainer → or see the full cheat sheet.

Frequently asked questions

What is the AutoSum shortcut in Excel?

Alt+= on Windows. On a Mac it is Cmd+Shift+T. Both insert a SUM formula for the numbers above or to the left of the selected cell.

Can I AutoSum several columns at once?

Yes. Select the empty cells under all the columns and press Alt+= to add a total to each one.

Does AutoSum work for average or count?

The shortcut always inserts SUM. Use the arrow next to the AutoSum button on the Home tab to pick Average, Count, Max or Min.

More shortcut guides

Insert & delete rows and columnsMerge & Center and Wrap TextPaste values onlyUndo, redo and repeatHide & unhide rows and columnsStrikethrough shortcutInsert today's date and timeSwitch, add and rename sheets