Excel AutoSum Shortcut: How to Use Alt+=

In Excel for Microsoft 365 on Windows, the AutoSum shortcut is Alt+=: select the blank cell where you want the total, press the keys, check the proposed range, and press Enter. AutoSum inserts a SUM formula, so the result updates when the referenced numbers change.

The Windows AutoSum shortcut

Press and hold Alt, then press the equals key. The shortcut is commonly written as Alt+=; the plus sign means the keys are used together, not that you need to press the plus key. On a typical US keyboard, the equals key is beside the Backspace key. Excel usually displays a suggested formula in the selected cell and outlines the cells it plans to add.

Review that outline before accepting the formula. Press Enter to confirm it, or click the formula bar and edit the cell references if Excel has chosen the wrong range. Press Esc to cancel the suggestion. AutoSum is a quick way to create a total, but it does not verify whether the selected numbers are the ones you intended to include.

How to add a column with AutoSum

For a simple column total, put the active cell in the empty cell directly below the numbers. Then use the shortcut and confirm Excel’s selection. For example:

Enter monthly amounts in cells B2 through B6 and leave B7 empty.
Select B7, the cell where the total should appear.
Press Alt+= and inspect the outlined range.
Press Enter to accept the suggested formula.

With values of 120, 85, 95, 100, and 100 in B2:B6, the formula Excel inserts in B7 is =SUM(B2:B6), which returns 500. SUM adds the values in the specified cells; it does not replace them or convert the result to a fixed number. If any of those five inputs changes, the total recalculates.

How Excel chooses the range

AutoSum looks at nearby cells to guess the numbers you want to total. When the active cell is below a continuous list of numbers, Excel will generally propose the cells above it. When the active cell is to the right of a row of numbers, it will generally propose the cells to the left. The outlined range and the formula text are the useful checks: do not assume the guess is correct just because the total looks plausible.

A blank cell, a text label, or another populated area can affect where Excel decides the list begins or ends. For instance, a blank within a column may cause Excel to select only the numeric block nearest the output cell rather than numbers farther above the gap. If a heading or an unrelated number is adjacent to the data, the proposed range may also need adjustment. You can drag across the correct cells while editing the formula, or type the correct range reference directly.

AutoSum works with cells that contain numbers and can include empty cells in the selected range without changing the total. Text in referenced cells is not added as a numeric value. A number stored as text may therefore be omitted, even if it looks like a number on the worksheet. If a total seems too small, check both the selected range and the underlying values.

Adding a row or several totals

To total a row, select the empty cell immediately to the right of the row’s numbers and press Alt+=. Excel usually proposes the numbers to the left. The same basic rule applies as with a column: inspect the outline and confirm only when the range includes the intended cells. You can also select a blank cell at the end of a horizontal range and use the AutoSum button on the ribbon if the keyboard shortcut is inconvenient.

You can create multiple totals in one operation when the output cells form a suitable selection. For example, select the blank cells beneath several adjacent columns of numbers, then invoke AutoSum. Excel can propose a separate total for each column. Check each result, especially if the columns have different lengths, gaps, or nearby labels. Another option is to complete one total, then copy or fill its formula across or down; verify the references after copying, because relative references adjust as a formula moves.

What the AutoSum button can do

The shortcut uses Sum by default. The ribbon button also offers other common calculations. In Excel for Windows, find it at Home > AutoSum or on the Formulas tab. Open the button’s dropdown to choose Sum, Average, Count Numbers, Max, or Min. Excel still uses nearby cells to suggest a range, so check the selection regardless of which option you choose.

These choices answer different questions. Sum adds numeric values; Average calculates their arithmetic mean; Count Numbers counts cells containing numbers; Max returns the largest value; and Min returns the smallest. A count is not a sum, and Count Numbers does not count text entries in the same way as numeric cells. If you choose an option from the dropdown, the result is still a formula that recalculates when its inputs change.

Common AutoSum problems

The wrong cells are outlined: edit the suggested range before pressing Enter. Check for blank rows, headings, extra figures, or an adjacent block that may have confused the range detection.
The total is lower than expected: confirm that every intended cell is included and check whether some apparent numbers are stored as text. Also check whether a value is actually blank or contains a formula returning an empty string.
The formula appears instead of a result: check whether the cell is formatted as Text or whether Show Formulas is turned on. Change the cell to a suitable number format and, if needed, re-enter the formula so Excel evaluates it.
The displayed total does not change: verify that calculation is set to Automatic under Formulas > Calculation Options. In Manual calculation mode, formulas may not update until recalculation is requested.
The shortcut does nothing: make sure a worksheet cell is active and try the ribbon button. Keyboard layouts, remote desktop settings, or other software can intercept key combinations.

Remember that AutoSum creates a formula, not a permanent snapshot. If you need a fixed value, copy the result and use Paste Special to paste values. Do this only when you no longer want the result to update with its source data.

Windows, Mac, and Excel for the web

The instructions above are for desktop Excel on Windows. In Excel for Mac, the AutoSum shortcut is generally Command+Shift+T. Mac keyboard layouts and Excel settings can affect shortcut behavior, so use the ribbon’s AutoSum command if that combination is unavailable or conflicts with another command.

In Excel for the web, keyboard shortcuts can depend on the browser and how keyboard access is configured. The ribbon’s AutoSum command is an alternative when Alt+= does not work as expected. The basic workflow is the same across versions: choose the output cell, invoke AutoSum, inspect the proposed range, and confirm. If you are following instructions for a different platform, use its displayed ribbon labels and available shortcut help rather than assuming every desktop shortcut behaves identically.

When to use a different method

AutoSum is well suited to quick totals at the edge of a straightforward block of data. Typing a SUM formula directly is useful when the cells are scattered, the range is not adjacent to the result, or you want to be explicit about what is included. You can also select a range and look at Excel’s status bar for a quick Sum without inserting a formula; that is convenient for a temporary check, but it does not place a total in the worksheet.

For a filtered list, ordinary AutoSum may not match the idea of totaling only the rows currently visible. A regular SUM includes values from hidden or filtered-out rows if they are in its range. Use a function designed for subtotaling when the total must respond to filters, and confirm its behavior for manually hidden rows as well. In every case, the right choice depends on whether you need a visible worksheet result, a changing formula, or only a quick on-screen check.

Frequently Asked Questions

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

Do I press the plus key for Alt+=?
No. The notation means hold Alt and press the equals key. On a standard US keyboard, the equals key is available without Shift; keyboard layouts can differ.

What is the AutoSum shortcut on a Mac?
Excel for Mac generally uses Command+Shift+T for AutoSum. If the shortcut is unavailable in your setup, use the AutoSum command on the ribbon.

Can AutoSum add a row instead of a column?
Yes. Select the empty cell immediately to the right of the row’s values, use AutoSum, and check that Excel has outlined the intended cells to the left.

Does AutoSum include hidden or filtered-out rows?
A normal SUM includes cells in its range even when their rows are hidden or excluded by a filter. For filter-sensitive totals, use a subtotaling method instead of relying on ordinary AutoSum.

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.