In Excel for Microsoft 365 on Windows, press Alt+= (Alt plus the equals key) to insert an AutoSum formula. Excel usually detects the adjacent numbers and proposes a SUM formula; check the highlighted range, then press Enter to accept it.
The AutoSum shortcut in Excel
AutoSum is Excel’s built-in shortcut for quickly adding a row or column of values. It writes a regular formula into the selected result cell, so the total updates if the referenced numbers change. The shortcut is Alt+= on Windows; it is not a separate kind of calculation or a fixed total.
The fastest common workflow is to click the empty cell directly below a column of numbers, press Alt+=, and press Enter. For a row, click the empty cell immediately to the right of the numbers and use the same shortcut. Excel highlights the cells it intends to add, which gives you a chance to catch an incorrect selection before accepting the formula.
For example, with values 12, 8, 15, 10, and 5 in B2:B6 and the result cell in B7, the formula Excel should propose is =SUM(B2:B6). The result is 50. This is the same formula you could type yourself; AutoSum saves keystrokes and helps select a likely range.
How AutoSum decides what to add
Excel looks for a nearby block of numeric cells when you invoke AutoSum. In a blank cell beneath a column, it commonly looks upward; in a blank cell at the end of a row, it commonly looks left. It uses the surrounding layout to guess the range, rather than understanding which values have a particular business meaning.
A blank cell or text entry can affect the guess. If the values to add are separated by an empty row, Excel may select only the uninterrupted block nearest the formula cell. Labels are not added as numbers, but they can help mark the edge of a range. The proposed range appears with a moving outline or other selection highlight, depending on the view and version.
AutoSum can also work with a range you select first. Select the blank result cell along with the relevant adjacent data, or select a group of result cells positioned below or beside their data, and then invoke AutoSum. What Excel inserts depends on the selection’s shape and the neighboring cells, so inspect the formula and the highlighted references instead of assuming every layout will be interpreted correctly.
Use the shortcut step by step
- Arrange the values in a continuous row or column when practical, with a blank cell where the total should go.
- Click the result cell below the column or to the right of the row.
- Press Alt+= on Windows. Excel inserts a proposed formula and highlights its referenced cells.
- Check that the highlighted cells include every value you intend to add and exclude headings, earlier totals, or unrelated data.
- Press Enter to accept the formula. If the range is wrong, edit the reference before pressing Enter.
You can also put the formula in the cell first and adjust its range while Excel is in formula-editing mode. Drag across the intended cells or type the correct cell references inside the parentheses. When finished, press Enter. If you need to leave the proposed formula unchanged, press Esc to cancel the current edit.
Examples for columns, rows, and separate ranges
For an ordinary column total, suppose weekly quantities are in C3:C8 and C9 is the total cell. AutoSum can propose a formula that adds those six cells. The result depends on the values in the workbook; the shortcut does not supply sample numbers or a predetermined answer.
For a row total, with January through June amounts in D4:I4 and the total in J4, select J4 and use AutoSum. Excel should look left and propose the adjacent row. This layout is useful for a per-person or per-product total, while a column total can summarize each period across multiple records.
SUM can also add more than one range, even when the ranges are not next to each other. With item values in B2:B4 and B6:B8, and the total in B9, a formula that adds both ranges is =SUM(B2:B4,B6:B8). The cell layout is specified here; if B2:B4 contains 120, 80, and 100, and B6:B8 contains 40, 50, and 60, the answer is 450. The comma separates the function’s range arguments in standard English-language Excel syntax.
This multi-range formula is usually easier to enter directly than to expect AutoSum to infer separated blocks. It also makes the intended groups explicit. If a range includes a subtotal that already contains some of the same values, adding both the detail and subtotal can double-count them.
Choose and check the range deliberately
AutoSum is most reliable when the data is a single uninterrupted block and the result sits just outside it. Before accepting its suggestion, consider whether the intended total should include all rows, whether any row is a header, and whether a subtotal or grand total lies nearby. These checks matter especially in reports where several number blocks are stacked together.
- For a simple list: place the result directly after the final value, then inspect the highlighted range.
- For separated groups: use a formula with each intended range as a separate argument rather than relying on the automatic guess.
- For a long dataset: consider whether the total should include future rows added later. A fixed reference such as B2:B20 will not automatically expand to include a new value entered in B21.
- For filtered lists: be aware that SUM adds referenced values even when some rows are hidden by a filter. If you need a total that changes according to filtered or hidden rows, investigate SUBTOTAL or AGGREGATE and check their behavior for your specific layout.
One common misconception is that AutoSum always adds every visible number above the result. It does not guarantee that: it proposes a range based on the sheet structure. Another is that a displayed total cannot be wrong if the formula looks plausible. A formula may omit a row, include an unintended value, or double-count a subtotal, so reviewing the references is part of using the shortcut correctly.
Windows, Mac, and Excel for the web
This shortcut guidance is for Excel for Microsoft 365 on Windows. On many Mac keyboards and Excel for Mac configurations, the AutoSum shortcut is Command+Shift+T. Keyboard layouts and app versions can affect shortcut behavior; if that key combination does not invoke AutoSum on your Mac, use the ribbon command instead.
In desktop Excel, select the result cell and choose Home > AutoSum or Formulas > AutoSum. The button may show the Greek sigma symbol, Σ. These ribbon routes are useful when you do not remember the keyboard combination or when a keyboard layout makes it awkward. In Excel for the web, shortcut handling can vary with the browser and operating system, so using the ribbon’s AutoSum command is a practical alternative.
AutoSum is available across current desktop Excel editions, but keyboard shortcuts can differ by platform. If you work in a remote desktop, browser, or a system with its own keyboard shortcuts, the keypress might be intercepted before Excel receives it. The ribbon command avoids most uncertainty about which application handled the keystroke.
Common problems and fixes
If Alt+= does nothing, first make sure the Excel worksheet is active and that the selected cell can accept a formula. On some keyboards, the equals sign shares a key with another character, so use the key combination that produces equals on that keyboard. If the shortcut still fails, click AutoSum on the ribbon.
If Excel highlights the wrong cells, do not press Enter immediately. Select or type the intended reference while editing the formula. Check for blank rows, nearby numeric cells, and previously calculated totals that may have confused the guess. A reliable result comes from the correct range, not from the shortcut itself.
If the formula appears in the cell as text instead of showing a total, the cell may be formatted as Text, or the entry may have been preceded by an apostrophe. Change the cell format to General or Number, then re-enter the formula. Also check that Show Formulas is not enabled; that view displays formulas in worksheet cells instead of their calculated results.
If the result is zero or unexpectedly small, check whether the supposed numbers are stored as text. Imported data can look like numbers while Excel treats it as text, and SUM ignores text values in referenced cells. Converting the entries to numeric values may resolve the issue. If the result is too large, inspect for duplicated rows or a range that includes a subtotal as well as its underlying details.
AutoSum versus typing SUM
AutoSum and a manually entered SUM formula use the same function. AutoSum’s advantage is speed and a useful range guess for simple layouts. Typing the function yourself is more explicit and is often preferable for nonadjacent ranges, values on another worksheet, or a formula that should cover a carefully chosen set of cells.
For example, when the cells to add are in a single straightforward block, AutoSum reduces typing. When you know the exact references, typing a formula gives you direct control and makes it easier to document the calculation. Neither method validates whether the selected data is conceptually the right data; that remains a worksheet-design and review task.
For a table that grows over time, an Excel Table can make totals and references easier to manage than a fixed range. You can create a table with Insert > Table, then use its Total Row option to summarize a column. This is an alternative to repeatedly extending a conventional range, though it is not necessary for a small, stable list.
Frequently Asked Questions
What is the Excel shortcut for Sum?
In Excel for Microsoft 365 on Windows, press Alt+= to invoke AutoSum. Check the proposed range and press Enter to insert the SUM formula.
Does Alt+= add the numbers immediately?
No. It inserts or proposes a formula in the selected cell. Press Enter to accept it, and Excel calculates the result based on the referenced cells.
How do I sum a row instead of a column?
Select the blank cell immediately to the right of the row and use AutoSum. Confirm that the highlighted references cover the intended cells to the left.
What is the AutoSum shortcut on a Mac?
Command+Shift+T is used for AutoSum in many Excel for Mac configurations. If it does not work on your keyboard or version, select the cell and use Home > AutoSum or Formulas > AutoSum.
Why did AutoSum leave out some numbers?
Excel may have stopped at a blank row or chosen a nearby block instead of the full range. Edit the highlighted reference to include the intended cells before confirming the formula.
Can AutoSum add cells that are not next to each other?
It can be made to do so by editing the formula, but it may not guess separated blocks reliably. Enter a SUM formula with each intended range as an argument, and verify that no subtotal is counted twice.
Related
- Excel Reverse Undo Shortcut: What Works and What Doesn’t
- Excel Reverse Worksheet Order: How to Do It
- Excel Repair Software Free Full Version: What Works?
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Time Conversion Formula: Hours, Minutes, and MoreIf A2 contains an Excel time, multiply it by 24 to get decimal hours: =A2*24. For decimal minutes,…
- Find the Max Date in Excel: Formula, Filters, and FixesTo find the latest date in Excel, put your dates in a range such as B2:B20, then enter…
- Paste Numbers in Excel Without Formulas: Paste ValuesTo paste formula results as fixed numbers in Excel, copy the cells, select the destination, then choose Home…
- Excel Cell Range Average: Formula and ExamplesTo average a range in Excel, use AVERAGE: if A2:A5 contain 10, 20, a blank cell, and 0,…
- Excel Goal Seek Formula Alternatives That WorkExcel does not have a worksheet function called GOALSEEK; Goal Seek is a What-If Analysis command. The formula…
- How to Copy in Excel Without Formulas: Keep ValuesTo copy the results of formulas without copying the formulas themselves in Excel for Microsoft 365 on Windows,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.