Excel Sum Keyboard Shortcut: Use AutoSum in Seconds

In Excel for Microsoft 365 on Windows, press Alt+= to insert AutoSum, which creates a SUM formula for a nearby range; press Enter to accept it. For example, click the blank cell below a column of numbers, press Alt+=, check the suggested range, and press Enter to total it.

The AutoSum shortcut on Windows

AutoSum is Excel’s built-in shortcut for quickly adding numbers. The Windows keyboard combination is Alt+=: hold Alt and press the equals key. It is the same command as the AutoSum button, shown with a sigma (Σ) symbol on the ribbon. In many keyboard layouts, the equals key shares a key with the plus sign, but you do not need to type a plus sign; use the key that produces equals without adding Shift if your keyboard allows it.

When you invoke AutoSum, Excel looks at nearby cells and proposes a range. It usually chooses the uninterrupted block of numbers directly above the active cell, or to its left if you are totaling a row. Excel displays the proposed formula in the cell and outlines the referenced range. Press Enter to accept the suggestion, or edit the range before confirming if it is not right.

Click the empty cell where you want the total.
Press Alt+=.
Check the highlighted cells and proposed formula.
Press Enter to insert and calculate the total.

How AutoSum chooses what to add

AutoSum is a shortcut for creating a formula, not a separate calculator. In a blank cell below a continuous list of numbers, it generally selects the cells above. In a blank cell to the right of a continuous row of numbers, it generally selects the cells to the left. For instance, if the values occupy B2 through B5 and the active cell is B6, the suggested formula is =SUM(B2:B5). With 12, 18, 7, and 13 in those cells, the result is 50.

That automatic selection is convenient, but it is only a guess based on the layout. A blank cell within a list can make Excel treat the numbers on either side as separate blocks. Other nearby values can also influence which range it proposes. Always glance at the outlined cells before accepting the formula, especially in a worksheet with headings, subtotals, or several adjacent data columns.

If the outline is wrong, you can drag over the correct cells or edit the range shown in the formula before pressing Enter. For example, if the values you mean to add are in B2:B5 but Excel highlights only B4:B5, change the proposed reference to B2:B5. The colon in a reference such as B2:B5 means the range includes both endpoint cells and every cell between them.

Adding a row or several columns

AutoSum can work horizontally as well as vertically. To total values across a row, click the blank cell immediately to the right of the values and press Alt+=. Excel will usually suggest the continuous row to the left. The same principle applies: check the selection and confirm it with Enter.

You can also total several columns at once. Select the empty cells directly beneath the columns you want to total, then press Alt+=. For example, select B6:D6 when the figures are in B2:D5. Excel can insert a separate sum in each selected total cell, using the corresponding column above it. This is useful for a small report with several categories; inspect the formulas afterward to ensure each total covers the intended rows.

A similar approach works for several rows: select the empty cells immediately to the right of the rows, then invoke AutoSum. Excel fills totals across the selected cells when it can identify the adjacent data. If the selection is ambiguous, create one total first, verify it, and then fill or copy the formula as appropriate. The key is that the layout must make the intended ranges clear.

AutoSum compared with typing SUM

AutoSum saves keystrokes when the numbers form a simple, contiguous block next to the total cell. Typing a SUM formula gives you more control when the data is separated, the desired range is not adjacent, or you want to make the calculation obvious to someone reviewing the sheet.

With values in B2:B5 and the result intended for B6, the formula =SUM(B2:B5) returns 50 if those cells contain 12, 18, 7, and 13. This is the same calculation AutoSum would normally create for that layout. You can also add separate ranges: if B2:B4 contains 10, 20, and 30, and D2:D4 contains 1, 2, and 3, enter =SUM(B2:B4,D2:D4) in a result cell to get 66. The comma separates the two range arguments.

SUM is often preferable to adding individual cells with plus signs. A range reference is easier to check and can include more cells without making the formula unwieldy. It also updates when values in the referenced cells change. AutoSum does not lock a range or protect it from later changes to the worksheet; like any formula, its references should be checked if rows or columns are inserted, deleted, or rearranged.

Common AutoSum problems and fixes

If the result is too small, first compare the highlighted range with the cells you meant to include. A blank row can interrupt Excel’s guess, and an adjacent subtotal can lead the shortcut to select only part of the data. Edit the range to include the missing cells. If the formula looks correct but the result still surprises you, check whether the intended values are actually numbers: values stored as text are not treated as ordinary numeric entries by SUM in the same way as numbers.

If you see the formula displayed instead of a calculated answer, check whether the cell is formatted as Text or whether Show Formulas is enabled. Change the cell’s number format to General or an appropriate number format, then re-enter the formula. To toggle formula display in Windows Excel, use Ctrl+` (the grave-accent key, often near the top-left of the keyboard). This setting affects the worksheet view; it does not change the calculation itself.

A zero result can mean that the selected cells are empty, contain text rather than numeric values, or are not the cells you expected. Click the result cell and review its formula and colored reference outline. If a cell contains a formula that returns a number, SUM can include that result; if a cell contains text such as a note or a number stored as text, it may not contribute to the total. Correct the source data or adjust the range rather than assuming the shortcut failed.

Finally, remember that a sum is not automatically a count of visible rows. SUM includes values in hidden rows when those cells are within the referenced range. If you need a total that changes according to filtered or hidden rows, choose a function designed for that behavior rather than assuming AutoSum will exclude them.

Using the shortcut on Mac and Excel for the web

On Excel for Mac, the AutoSum keyboard shortcut is Command+Shift+T, rather than Windows’ Alt+=. As on Windows, check the suggested range before confirming. Keyboard behavior can depend on the Mac’s keyboard layout and Excel version, so the ribbon’s AutoSum command is a dependable alternative if the combination is unavailable or intercepted.

In Excel for the web, keyboard combinations can be affected by the browser and operating system. When Alt+= does not activate AutoSum, use the AutoSum command on the ribbon while the worksheet cell is selected. The web version can also show shortcut help in its menus or help interface. The important workflow is unchanged: select the destination cell, invoke AutoSum, inspect the range, and confirm the formula.

If a keyboard shortcut conflicts with another application or a browser command, do not keep repeating it without checking the active cell. Use the ribbon command instead, then confirm that Excel inserted a formula into the intended cell. This is especially useful when working remotely, using a compact keyboard, or switching between Mac, Windows, and browser versions.

When to use another method

AutoSum is a good fit for a quick total beside a clearly organized block of numbers. It is less suitable when the records are scattered, when you need a conditional total, or when hidden rows must be treated specially. In those cases, write a formula that explicitly describes the calculation or use the relevant Excel feature. A direct SUM formula is often all that is needed for nonadjacent ranges, while more specialized requirements call for a function chosen for that task.

For a one-off check, a calculator may be enough, but it will not update when worksheet values change. A formula keeps the result connected to its source cells, making it more useful in a working budget, inventory list, or sales report. If you share the workbook, a visible formula also makes the method easier for another person to inspect than a manually typed total.

AutoSum also does not decide what counts as a meaningful total. If a column mixes transaction values, headings, and subtotals, first decide which rows belong in the calculation. Including existing subtotals along with the underlying entries can double-count amounts. The shortcut can create a syntactically valid formula while still summing the wrong business figures, so layout and range review matter as much as the keystroke.

Frequently Asked Questions

What is the keyboard shortcut for Sum in Excel?
In Excel for Microsoft 365 on Windows, press Alt+= to insert AutoSum. On Mac, use Command+Shift+T. Check the suggested range and press Enter to confirm.

Does Alt+= automatically calculate the total?
It inserts a SUM formula into the active cell and proposes a nearby range. Press Enter to accept and calculate it. You can edit the proposed range before confirming.

How do I sum a row instead of a column?
Select the blank cell immediately to the right of the row’s numbers and invoke AutoSum. Excel usually selects the continuous cells to the left; inspect the outline before accepting.

Why is AutoSum leaving out some numbers?
Excel may have stopped at a blank cell or selected a shorter adjacent block. Review the highlighted range and adjust it to include the intended cells. Also check that the values are numeric.

Can I use AutoSum for more than one column?
Yes. Select the empty total cells beneath the columns and invoke AutoSum. Excel can insert a separate formula for each column when the surrounding layout makes the ranges clear; verify the results and references.

What is the difference between AutoSum and SUM?
SUM is the function that adds values. AutoSum is a shortcut and ribbon command that helps insert a SUM formula, often with a range selected automatically. You can type or edit SUM yourself when you need precise control.

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.