How to Copy a Sum From Excel’s Status Bar to a Cell

How-to basics · Updated November 20, 2026

To copy a selected range’s sum from Excel’s status bar, select the cells, make sure Sum is enabled on the status-bar menu, and click the displayed sum. Then select a destination cell and press Ctrl+V. This is a quick way to reuse a total without typing a formula; the copied result is a value, not a live calculation.

What You’ll Need

  • Excel for Microsoft 365 on Windows, with a workbook open.
  • A range containing the numbers you want to total. The cells do not have to be adjacent, but selecting a straightforward range makes it easier to confirm what is included.
  • A destination cell, either in the same worksheet or another place where you can paste the result.

Save the workbook if you are making other important changes. Copying the status-bar result itself does not edit the selected cells, but pasting will replace anything already in the destination cell.

Step-by-Step

  1. Select the cells to add. Click and drag across the range, or click the first cell, hold Shift, and click the last cell. You can also select a whole range by clicking the first cell and pressing Ctrl+Shift+End, but only use that shortcut if the resulting selection really is the range you intend to total. Check the highlighted cells before continuing. If the numbers are in separate places, hold Ctrl while selecting additional ranges on Windows; check the selection carefully because it is easy to include an unintended cell.
  2. Look for the calculation at the bottom of the Excel window. With cells selected, Excel normally displays quick calculations on the status bar, such as Average, Count, and Sum. The status bar is the strip along the bottom of the workbook window. If you see a Sum value, note it briefly so you can check the pasted result later. If Sum is not visible, continue to the next step.
  3. Turn on Sum if it is hidden. Right-click an open area of the status bar. In the list of status-bar calculations, click Sum so it has a check mark. Close the menu by clicking back in the worksheet. The calculation should now appear when you select numeric cells. This setting controls what Excel shows; it does not add a formula to the sheet or change the selected data.
  4. Click the displayed Sum result. Click directly on the number shown after “Sum” in the status bar—not on the worksheet cell and not on the status-bar menu. In supported desktop versions, Excel copies that calculation to the clipboard. The selected range should remain selected. If you click the label or an empty part of the status bar and nothing happens, try clicking the number itself.
  5. Choose where the total should go. Click the destination cell. It can be an empty cell in the same sheet, a different worksheet, or another open application. If you are pasting into another workbook or app, confirm that it is ready to receive the clipboard content. Be aware that choosing a cell with existing content and pasting will overwrite that content.
  6. Paste the copied sum. On Windows, press Ctrl+V, or use Home > Paste. Excel inserts the copied total as a value. To paste into a different application, use that application’s paste command or Ctrl+V. The pasted number should match the Sum shown on the status bar, though its displayed decimal places may depend on the destination cell’s number format.
  7. Confirm the result. Click the destination cell and check the value in the formula bar or cell display. You can compare it with the number you noted from the status bar. If Excel pastes something unexpected, undo the paste immediately with Ctrl+Z, reselect the intended source cells, and repeat the copy and paste steps.

The keyboard shortcuts differ on Mac: use Command+C and Command+V for ordinary copy and paste, although copying the status-bar calculation is done by clicking its displayed value rather than pressing a copy shortcut. In Excel for the web, status-bar options and copying behavior can vary by browser and release. If clicking the result does not copy it, use the formula alternative in Troubleshooting instead.

Common Mistakes

  • Clicking the wrong part of the status bar. The copy action is associated with the displayed calculation value. Opening the status-bar menu or clicking the word “Sum” may not copy anything. Click the number itself.
  • Leaving out cells or including extra ones. Excel totals the current selection, not necessarily the data block you meant to use. Check the highlighted range, especially if you selected nonadjacent cells or used a keyboard shortcut.
  • Assuming the copied result remains linked to the source. A status-bar copy is a fixed value. If the original numbers later change, the pasted total will not update. Use a SUM formula when you need a total that recalculates.
  • Pasting over existing data. Clicking the destination and pressing Ctrl+V replaces its contents. Use an empty cell or make sure the existing content is safe to overwrite. If you paste into a cell with a formula, the formula is replaced by the copied number.
  • Reading a formatted display as the exact stored value. The status bar may show a rounded number, depending on the values and the display. A destination cell might also show fewer decimal places than the value it contains. Increase displayed decimals or inspect the formula bar if precision matters.
  • Expecting text that looks numeric to be included. Cells containing numbers stored as text may not contribute to the quick Sum in the way you expect. Check the source cells and compare with a worksheet formula if the result appears too small.

Tips

Use the status-bar method when you need a one-time total for a message, note, report, or quick check. It is especially handy when you do not want to add a temporary formula to the worksheet. Before copying, make sure the selection contains the correct rows and columns; the status bar does not tell you which individual cells contributed to the result.

You can enable other status-bar calculations from the same right-click menu. For example, Average can help you check a typical value, while Count can help you see how many selected cells contain entries. These are separate quick calculations. Turning on Sum does not automatically mean that every other statistic is displayed, and the list of available choices can depend on the selection and Excel version.

For recurring reports, use a formula rather than a copied status-bar value. For example, with the numbers to add in A2:A10, enter =SUM(A2:A10) in a separate result cell. If the values in A2:A10 are 3, 7, 10, 12, 18, 20, 25, 30, and 35, the formula returns 160. The result updates when those source values change. Adjust the cell references to match your data, and avoid placing the formula inside the range it is adding.

If you want to keep a copied result from being changed accidentally, consider placing it in a clearly labeled total area and formatting that cell consistently with the rest of the sheet. A label such as “One-time total” can help distinguish a fixed pasted number from a formula-driven total. Keep a note of the source range if someone else may need to verify where the value came from.

Troubleshooting

Sum does not appear: Right-click the status bar and select Sum in its menu. Then select the source cells again. If no calculation appears, check that at least one selected cell contains a number recognized by Excel. A selection containing only blank cells or text may not show a useful sum.

Clicking the number does not copy it: Make sure you are using a desktop Excel version that supports copying the status-bar calculation, and click the numeric result rather than the label. Some interface builds, platforms, or remote desktop setups may behave differently. Try a small test range and paste into a blank cell. If it still fails, use a SUM formula in a worksheet cell and copy that cell instead.

The pasted result is wrong: Undo the paste, reselect the intended cells, and check whether hidden rows, filtered data, text-formatted numbers, or extra cells affected the selection. The status-bar Sum generally totals the selected numeric cells; do not assume it is automatically restricted to the rows currently visible in a filtered list. For a total that should follow visible rows only, use a suitable worksheet formula rather than relying on the status bar.

The number looks different after pasting: Select the destination cell and inspect the formula bar. If the underlying value is correct but the cell shows fewer decimals, change its number format or use Home > Increase Decimal. The status bar and destination cell can display the same value with different rounding or formatting.

Ctrl+V pastes something else: The clipboard may have been replaced after you clicked the status-bar result, or the click may not have copied the calculation. Select the source range, click the Sum value again, and paste immediately into a blank test cell. Avoid copying other content between those actions.

Frequently Asked Questions

Does copying Sum from the status bar create a formula?
No. It copies the current calculation as a value. To keep a total connected to the source cells, enter a SUM formula in a worksheet cell instead.

Can I paste the status-bar sum into another workbook?
Yes, if the calculation has been copied to the clipboard. Switch to the other workbook, select a destination cell, and paste. The pasted number is not linked to the source workbook.

Can I copy the Average or Count shown on the status bar too?
In supported desktop versions, click the displayed calculation value you want to copy. Enable the relevant calculation through the status-bar right-click menu first if it is not shown.

Will the status-bar Sum include hidden or filtered-out rows?
Do not rely on it to calculate only visible rows. It reflects the selected cells and can include values that are not currently visible. Use a formula designed for the visibility rules you need when that distinction matters.

Why does my total differ from a calculator?
Check the selected range, numbers stored as text, hidden rows, and decimal precision. For a dependable cross-check, place a SUM formula in a cell using exactly the intended range and compare its result with the status-bar value.

Can I use this on Excel for Mac or the web?
Excel for Mac has a status bar and may provide the calculation-copy action in supported releases; use Command+V to paste. Excel for the web can differ by browser and feature availability. If clicking the result is unavailable, enter a SUM formula in a cell and copy its result.

Related

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.