To sum a column quickly in Excel for Microsoft 365 on Windows, select the blank cell directly below the numbers and press Alt+=. Excel inserts an AutoSum formula; press Enter to accept it. You can also type a SUM formula yourself or select a range using the keyboard. The steps below explain each option, how to check the selected cells, and what to do if the total looks wrong.
What You’ll Need
- An Excel worksheet containing the numbers you want to add. The values should be real numbers, not numbers stored as text.
- A blank cell for the result. For a column, this is usually just below the values; for a row, it is usually just to the right.
- A keyboard. These steps are for Excel for Microsoft 365 on Windows. A Mac shortcut difference is noted where relevant.
You do not need to install an add-in or use a mouse. If the worksheet contains headings, blank rows, or other nearby numbers, take a moment to identify the exact range you intend to total before using AutoSum.
Step-by-Step
- Open the worksheet and identify the values. Find the column or row you want to add, then note its first and last cell addresses. For example, a list in B2 through B6 is a vertical range, while D4 through H4 is a horizontal range. Check that the cells contain the values you mean to include; a heading or an existing total should not be part of the data range.
- Choose where the answer should appear. For a column, click or use the arrow keys to move to the first blank cell below the numbers. For a row, move to the first blank cell to the right. The result cell should not contain a value you need to keep. Pressing Enter after AutoSum will put the calculated result in this active cell.
- Start AutoSum with the keyboard. On Windows, press Alt+= (hold Alt and press the equals key). Excel displays a proposed formula and usually outlines the cells it plans to add. When the data are directly above or to the left, Excel normally guesses the adjoining block of numbers. Do not press Enter automatically if the outline does not match the range you intended.
- Check or correct the proposed range. Look at the outlined cells and the formula shown in the active cell or formula bar. If Excel has selected too few or too many cells, use the arrow keys to adjust the selection before confirming. You can also press Escape to cancel and select the range yourself. A heading or blank cell can affect Excel’s guess, so verify the range even when the suggested answer looks plausible.
- Confirm the total. When the proposed range is correct, press Enter. The total appears in the active cell. Select the result cell afterward if you want to inspect the formula bar and make sure the formula refers to the intended cells. AutoSum leaves the source values unchanged; it calculates a result in the destination cell.
- Enter SUM directly when you want to specify the range. With the values in B2:B6 and the result cell in B7, type
=SUM(B2:B6)in B7 and press Enter. If the five values are 12, 8, 15, 6, and 9, the result is 50. This method is useful when the data are not immediately beside the result cell or when AutoSum guesses the wrong boundary. - Select a range without using the mouse. Move to the first cell in the range with the arrow keys. Hold Shift and press the arrow key in the direction of the remaining values to extend the selection. For a larger, uninterrupted block on Windows, Ctrl+Shift+Down Arrow or Ctrl+Shift+Right Arrow extends the selection to the end of the data region. Then type the formula in the result cell, or use the selection as a reference while editing a formula. For example, with values in D4:H4 and the result cell I4, type
=SUM(D4:H4)in I4; values 4, 7, 3, 11, and 10 produce 35. - Repeat the total for other rows or columns if needed. You can use AutoSum in each result cell, checking each proposed range. If you already have a correct formula and adjacent rows follow the same layout, copy it to the next result cell with Ctrl+C, move to the destination, and press Ctrl+V. Excel adjusts relative cell references when you copy a formula, so inspect the copied result if the pattern changes or the rows contain gaps.
On Excel for Mac, the AutoSum shortcut is usually Command+Shift+T. Keyboard settings and Excel versions can affect shortcut behavior, so if that combination does not work, use the ribbon or type the SUM formula. In Excel for the web, the Windows Alt+= shortcut may be intercepted by the browser or system; entering a formula in the cell is a dependable keyboard option.
Common Mistakes
- Accepting an incorrect AutoSum range. Excel guesses based on nearby cells. A blank cell within a list can make it stop early, while adjacent numbers can make it include an unrelated value. Always check the outlined cells before pressing Enter.
- Including the result cell in the range. If a formula tries to add its own cell, Excel reports a circular reference. Place the total outside the source range, or edit the formula so it refers only to the values being added.
- Leaving out the first or last value. This can happen when typing a range address or adjusting the selection. Check both endpoints, not just the number of highlighted cells. A range is inclusive of its first and last addresses.
- Assuming every visible entry is numeric. Values imported from another system may be stored as text, and SUM ignores text in referenced cells. A total can therefore be lower than expected even when every row appears populated.
- Using plus signs for a long list. Typing each cell separately is easy to mistype and difficult to maintain. SUM with a range is clearer, and a continuous range automatically includes new values inserted within its boundaries.
- Confusing a displayed value with the stored value. Currency or decimal formatting can hide precision, and rounded-looking cells may still contain more decimal places. The total uses the underlying values, not just the digits currently shown on screen.
Tips
- Use a consistent layout. Keep each list in a continuous block with a clear heading and a blank total cell at its edge. This makes AutoSum’s range guess more predictable and makes the worksheet easier to review later.
- Use keyboard navigation to move around quickly. On Windows, Ctrl+Arrow moves to the edge of a contiguous data region, while Shift+Arrow extends a selection one cell at a time. On Mac, Command+Arrow generally moves to the edge of a data region; use Shift with the relevant arrow key to extend a selection. Navigation behavior depends on whether intervening cells are blank.
- Use the formula bar to audit a result. Select the total and read the formula bar. Confirm that the range starts and ends at the intended cells. This is a quick check after AutoSum, after copying a formula, or when another person has edited the sheet.
- Keep the total separate from raw data. A dedicated total row or column makes it less likely that future calculations accidentally include an earlier total. If you add new records regularly, consider using an Excel table so that data and summary areas remain easier to distinguish.
- Know what you are adding. SUM adds numeric values, including negative numbers and decimals. It does not count blank cells as extra values, and blank cells do not change the result. If you need to count entries rather than add their amounts, use a counting function instead of a sum.
- Use the ribbon if a shortcut is unavailable. In Excel for Windows, go to Home > Editing > AutoSum. You can reach ribbon commands with the keyboard by pressing Alt and following the Key Tips displayed on screen. This is useful if another program captures a shortcut or your keyboard layout differs.
Troubleshooting
- Alt+= does nothing. Make sure Excel, rather than another window, is active and that a worksheet cell is selected. Some keyboard layouts place the equals sign behind another key, so use the key combination that actually produces equals on your keyboard. If the shortcut remains unavailable, enter a SUM formula directly or use Home > Editing > AutoSum.
- The formula is visible in the cell instead of a number. The cell may be formatted as Text, or Excel may be treating the entry as ordinary text. Change the cell format to General or Number, edit the formula, and press Enter again. Also check that the entry begins with an equals sign and that Show Formulas is not turned on. In Excel for Windows, Ctrl+` toggles Show Formulas; the backtick key is usually near the top-left of the keyboard.
- The result is zero or smaller than expected. Check whether the source values are stored as text, whether the formula range skips any cells, and whether the entries include unexpected blanks. A quick visual check is not always enough to identify text-formatted numbers. You can select a source cell and inspect its alignment or warning indicator, then convert the values to numbers using Excel’s available conversion prompt or data tools.
- Excel reports a circular reference. The formula may include the cell containing the result. Select that cell, inspect the formula bar, and correct the ending address so the range stops at the last source value. For example, if the total is in B7, the range should not extend through B7 itself.
- The total changes when rows are hidden or filtered. SUM includes values in hidden rows, including rows hidden by a filter. If you want a filtered list to total only visible rows, use SUBTOTAL instead. With values in B2:B20 and the result outside that range, enter
=SUBTOTAL(9,B2:B20). The 9 argument specifies SUM behavior; filtered-out rows are excluded. If you also need to exclude rows hidden manually, use 109 instead of 9. - The formula works but displays too few decimal places. The result may be formatted to show fewer decimals than it contains. Select the result and increase the displayed decimal places from the Home tab’s Number group, or change its number format. Formatting changes how the answer looks, not the underlying sum.
Frequently Asked Questions
What is the keyboard shortcut for AutoSum in Excel?
In Excel for Microsoft 365 on Windows, press Alt+= with a result cell selected. Review the suggested range, then press Enter. On Mac, the usual shortcut is Command+Shift+T; if it is unavailable, enter SUM directly or use the ribbon.
Can I sum cells that are not next to each other?
Yes. Type a SUM formula and list the individual cell references separated by commas. With values in B2, B5, and B8 and the answer in B10, enter =SUM(B2,B5,B8) in B10. Check that each reference points to a cell you want included. For scattered groups, you can also include separate ranges as arguments.
Does AutoSum add numbers across a row as well as down a column?
Yes. Select the blank cell immediately to the right of the row and press Alt+= on Windows. Excel usually proposes the numbers to the left. Check the highlighted cells before confirming, especially if the row contains blanks or unrelated values.
Will SUM include hidden or filtered-out rows?
SUM includes hidden values, including values in filtered-out rows. For a filtered list where only visible records should contribute, use SUBTOTAL with its SUM option, as shown above. Decide whether manually hidden rows should count too, because SUBTOTAL’s function number determines that behavior.
Why is my total wrong even though the formula looks right?
Check the selected range, look for numbers stored as text, and consider whether the worksheet has hidden or filtered rows. Also confirm that you have not included a prior total or omitted a value at either end of the range. Inspecting the formula bar and source cells usually reveals the issue.
Related
- How to Rotate a Picture in an Excel Cell in Microsoft 365
- How to Rotate an Image in an Excel Cell: Steps and Tips
- How to Rotate an Excel Spreadsheet in Word: Easy Steps
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Share a Room Calendar in Outlook and Set AccessTo share a room calendar in Outlook, open the room’s calendar, use the calendar’s sharing controls to invite…
- Excel Sum by Cell Color: Methods That Actually WorkExcel does not have a built-in SUMIF function that adds cells based on fill color. To total one…
- How to Disable Track Changes in Excel Without Losing DataTo disable Excel’s legacy Track Changes feature in Microsoft 365 for Windows, open the workbook, go to Review…
- Excel Drop-Down Lists with Named Ranges: Setup and TipsTo create an Excel drop-down list from a named range, define a name for the cells containing your…
- How to Add Page Numbers in MLA Format in WordTo add MLA-style page numbers in Word, insert an automatic page number in the top-right header, then place…
- How to Hide Long Text in Excel Cells Without Deleting ItTo keep long text from showing across neighboring cells in Excel, make the cells to its right non-empty,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.