Excel Sum Shortcut Keys: AutoSum, Examples, and Tips

In Excel for Microsoft 365 on Windows, press Alt+= to insert an AutoSum formula; check the highlighted range, then press Enter to accept it. The shortcut usually creates a SUM formula for the adjacent numbers above or to the left of the selected cell.

The main Excel sum shortcut

AutoSum is a quick way to total a row or column without typing the function or selecting its range by hand. Click the empty cell where you want the answer, press Alt+=, review the proposed range, and press Enter. Excel places a formula in the cell, so the result updates if the referenced values change.

On a standard US keyboard, press Alt and the equals key; you do not need to type a plus sign separately. The key combination is often written as Alt+= because the equals key shares a key with the plus sign. Keyboard layouts differ, so if the shortcut does not work, use the ribbon route: Home > AutoSum.

For example, with 12, 18, 9, and 21 in cells B2:B5 and the result intended for B6, AutoSum can create =SUM(B2:B5) in B6. The total is 60. Check that Excel has included the cells you meant to add before accepting the suggestion.

How AutoSum chooses what to add

AutoSum looks for a nearby block of numeric data and proposes a range. When the active cell is below a column of numbers, Excel generally selects the numbers above it. When the active cell is to the right of a row of numbers, it generally selects the cells to the left. This makes the shortcut especially convenient for totals placed at the edge of a small table.

Excel’s guess is not a guarantee that the range is right. Blank cells, nearby figures, labels, and table layout can affect what it selects. A blank row may make Excel treat data above it as a separate block, for example. After pressing Alt+=, look at the moving border around the proposed range and at the formula shown in the formula bar. You can adjust the cell references before pressing Enter.

AutoSum does not add numbers by itself outside the selected range. It inserts a formula that refers to cells. That distinction matters: if a later edit changes a value inside the referenced range, the total recalculates; if you add a new value just beyond the range, Excel may not include it automatically.

Sum a column or row

To total a column, click the blank cell immediately below the numbers and press Alt+=. To total a row, click the blank cell immediately to its right and press the same shortcut. In either case, inspect the suggested references before confirming. If there is a heading or other content between the values and the total cell, Excel may stop at that boundary or propose an incomplete range.

For a row example, suppose A4:D4 contain 12, 18, 9, and 21, and E4 is the intended total cell. With that layout, the formula is =SUM(A4:D4), and the result is 60. For a column example, suppose C2:C5 contain 10, 15, 20, and 5, and C6 is the total cell. With that layout, the formula is =SUM(C2:C5), and the result is 50.

You can also type the function manually when you want more control. For a cell layout with the values in C2:C5 and the total in C6, enter =SUM(C2:C5) in C6; the result is 50. The same formula can be built by typing =SUM(, selecting the range, typing the closing parenthesis, and pressing Enter. AutoSum saves those steps when Excel’s range guess is correct.

Insert several totals at once

AutoSum can help with a total row or total column spanning several adjacent numeric columns. Select the empty cells where the totals should go, press Alt+=, and review what Excel proposes in each selected cell before confirming. For example, you might select the blank cells beneath three sales columns and use the shortcut to create a separate column total in each one. Confirm that each formula uses the intended data column rather than a neighboring column.

This is useful when a table has repeated categories, such as monthly sales by product. It is still worth checking each result, especially if the columns have gaps, text, or different lengths. If the selection does not produce the formulas you expect, undo with Ctrl+Z and create the totals one at a time, or enter each formula manually.

When totals are laid out in a row, the same principle applies: select the intended empty total cells at the right edge of the data and use AutoSum. The shortcut is a convenience, not a command to add every number in the worksheet, so the active selection and surrounding layout determine the proposed formulas.

AutoSum, the SUM function, and the status bar

AutoSum is the shortcut and ribbon command that helps insert a formula. SUM is the Excel function that performs the addition. Using the shortcut does not create a special kind of total; in ordinary cases, it inserts a standard SUM formula that you can edit like any other formula.

If you only need to check a total temporarily, you may not need a formula. Select the cells and look at the status bar at the bottom of the Excel window. It can display Sum for a selection of numeric cells. If Sum is not shown, right-click the status bar and enable the Sum calculation. This display does not put a result in a worksheet cell, so it is useful for a quick check but not for a report or calculation that other formulas must reference.

Choose a cell formula when the total needs to remain visible in the workbook and update as the data changes. Use the status-bar result when you only want a quick calculation. Use AutoSum when you want a formula quickly and the data is arranged in a clear row or column.

Common AutoSum problems and fixes

The wrong range is selected: Check the highlighted cells before pressing Enter. Edit the reference in the formula bar or select the right range manually. This often happens when another block of numbers is nearby.
The total excludes newer data: If you entered figures below the original range, the formula may still stop at the old last row. Edit the formula to include the added cells, or place the data in an Excel table so formulas and table ranges can expand more reliably.
A blank row interrupts the suggestion: Excel may treat a blank row as the end of the adjacent block. Select the complete range yourself or adjust the formula before accepting it.
The total is zero or unexpectedly small: Check whether the apparent numbers are stored as text. SUM adds numeric values in referenced cells, not text that merely looks like a number. Correct the underlying data or convert the text values to numbers, then recalculate.
Filtered or hidden rows still affect the answer: A normal SUM formula includes numeric values in its referenced range even when some rows are hidden or filtered out. If you need a total that responds to filtering, use a suitable SUBTOTAL formula instead; AutoSum is not a visible-rows-only command.
The shortcut seems to do nothing: Make sure you are editing a worksheet cell rather than typing inside a dialog or another application, and try the Home > AutoSum ribbon command. A different keyboard layout or shortcut conflict can also be a factor.

After creating a formula, you can verify it by selecting the result cell and inspecting the formula bar. For a small table, compare the result with a quick mental calculation or use the status bar on the source cells as a cross-check. If a formula points to the wrong range, correct the references rather than assuming the displayed total is right.

Windows, Mac, and Excel for the web

This guide focuses on Excel for Microsoft 365 on Windows, where the AutoSum shortcut is Alt+=. In Excel for Mac, the commonly used AutoSum shortcut is Command+Shift+T. Shortcut behavior can depend on the keyboard layout and Excel build; if it does not work, choose Home > AutoSum on the ribbon instead.

Excel for the web runs in a browser, where browser and operating-system shortcuts can affect key combinations. The ribbon’s Home > AutoSum command is a straightforward alternative when the keyboard shortcut is unavailable or intercepted. The command’s purpose is the same: insert a proposed sum formula based on the nearby range, which you should check before accepting.

Some laptops require an Fn key for certain keyboard functions, but Alt+= normally uses the key that produces the equals sign. If the keyboard does not produce the expected command, try the ribbon and confirm that the active cell is positioned next to the numbers to be totaled.

When to use a different approach

AutoSum is best for a straightforward contiguous row or column. If the values to add are scattered, type a SUM formula and specify the ranges you need, or select the cells while constructing the formula. For a stable total over a changing list, an Excel table can help keep the data organized and make formulas easier to maintain. For totals that must exclude filtered-out rows, consider SUBTOTAL rather than a normal AutoSum result.

Do not confuse a sum shortcut with a command to fill a formula down an entire column. Alt+= proposes totals; it does not automatically create a complete analysis or decide which records belong in a calculation. Check the scope, especially in worksheets with subtotals, blank separators, hidden rows, or multiple adjacent datasets. A few seconds spent reviewing the selected range can prevent a plausible-looking but incorrect total.

Frequently Asked Questions

What is the shortcut key for AutoSum in Excel?
In Excel for Microsoft 365 on Windows, press Alt+=. Excel proposes a SUM formula for nearby numbers. Check the proposed range and press Enter to accept it.

How do I sum a column in Excel with a keyboard shortcut?
Click the empty cell below the numbers, press Alt+=, check that the range above is correct, and press Enter. If Excel selects the wrong cells, edit the range before confirming.

How do I sum a row using AutoSum?
Click the empty cell immediately to the right of the row, press Alt+=, inspect the proposed cells to the left, and press Enter. The formula will total the selected row range.

What is the AutoSum shortcut on a Mac?
In Excel for Mac, the commonly used shortcut is Command+Shift+T. If that combination does not work with your keyboard or Excel version, use Home > AutoSum on the ribbon.

Why does AutoSum select the wrong cells?
Excel guesses the range from nearby data. Blank rows, adjacent number blocks, and irregular layouts can mislead that guess. Review the highlighted range or formula references, then adjust them before pressing Enter.

Does AutoSum include hidden or filtered rows?
Yes. A normal SUM formula includes numeric cells in its range even if rows are hidden or filtered out. For a result that changes with filtering, use an appropriate SUBTOTAL formula instead.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.