To paste formula results as fixed numbers in Excel, copy the cells, select the destination, then choose Home > Paste > Values (the clipboard icon marked 123). This pastes the displayed results instead of the formulas, so the numbers will no longer change when the cells they depend on change. In Microsoft Excel for Microsoft 365 on Windows, you can also press Ctrl+C, then Ctrl+Alt+V, choose Values, and press Enter.
Use this when you need to freeze calculations, share a formula-free copy, or replace formulas with their current results. Copy the cells first; cutting them is not the same as copying and pasting values. The steps below cover the Windows desktop app, with notes for Mac and Excel for the web.
What You’ll Need
- An Excel workbook with the source cells you want to copy. They can contain formulas, numbers, or a mix of both.
- A destination range in the same workbook or another workbook. For an in-place conversion, the source cells themselves can be the destination.
- Permission to edit the destination cells. Protected sheets, merged cells, or a restricted workbook can prevent pasting.
- If copying between workbooks, both workbooks should be open in Excel for the most predictable results.
Step-by-Step
- Check what is in the source cells. Select a cell and look at the formula bar. If it starts with an equals sign, it contains a formula; the grid shows the formula result. For example, a cell might display 250 while its formula bar shows a calculation. Paste Values will copy the result that Excel currently calculates, not the formula itself. If the cell already contains a number, pasting its value still avoids bringing over formatting or other cell properties.
- Select the source range. Click the first cell, then drag over the rest, or click the first cell, hold
Shift, and click the last cell. You can also select a range by clicking the Name Box to the left of the formula bar, typing a range such as B2:B20, and pressingEnter. Include every cell whose result you want to keep. If selecting a formula-generated spill range, select the entire spill range rather than just one part. - Copy, rather than cut, the selection. Press
Ctrl+Con Windows, or choose Home > Copy. A moving dashed outline usually appears around the copied range. Copying leaves the source cells in place while Excel holds their contents for pasting. Do not pressCtrl+X: cut moves cells and is not the right starting point for making a separate values-only copy. - Choose the destination. Click the top-left cell of the area where the results should go. For a separate copy, choose an empty range large enough for the copied cells. For a same-sheet conversion, click the original top-left cell again. Before replacing formulas in place, make sure you are happy to lose them; consider saving a separate copy of the workbook if you may need to edit those calculations later.
- Open the Values paste option. On the ribbon, go to Home > Paste and choose Values, shown with a clipboard and 123. In some ribbon layouts, click the arrow beneath Paste to expand the options. You can also right-click the destination and choose the Paste Values icon. Avoid the regular Paste command if you need to guarantee that formulas are not copied.
- Use Paste Special with the keyboard if preferred. On Windows, after copying, select the destination and press
Ctrl+Alt+Vto open the Paste Special dialog. Select Values, then pressEnter. This is useful when you want to use the keyboard without relying on the icon. If the dialog does not open, use the ribbon method; shortcut behavior can depend on keyboard settings or the app environment. - Check the pasted cells. Click one of the results and inspect the formula bar. A pasted formula result should appear as a number, date, text, or error value—not as a formula beginning with an equals sign. If you pasted into a separate range, change an input used by the original formula and check that the copied result stays the same. Undo immediately with
Ctrl+Zif the wrong content was pasted. - Save the workbook. Use
Ctrl+Safter confirming the result. If you pasted values over the formulas, saving makes the conversion part of the workbook. If you kept a separate values-only copy, label it clearly so you can tell it apart from the formula-driven source later.
On Mac: The ribbon method is also available in Excel for Microsoft 365 for Mac: use Home > Paste and select the Values option. Keyboard shortcuts differ from Windows and can vary with the keyboard and macOS settings, so the ribbon or the right-click Paste Values option is the most reliable route. If you open Paste Special from the Edit menu, choose Values in the dialog.
In Excel for the web: Copy the cells, select the destination, and use the Paste Values option on the Home ribbon or in the context menu when available. If a shortcut behaves differently in your browser, use the ribbon. Browser and operating-system shortcuts can take precedence over Excel shortcuts.
Common Mistakes
- Choosing regular Paste. Standard paste generally brings formulas along with the cells. A copied formula may adjust its references at the destination, making the new result different from what you expected. Choose the Values icon explicitly.
- Expecting the original formatting to come across. Values pastes the cell contents, not the complete original appearance. Font, fill color, borders, and number format may not transfer. The destination’s existing number format can affect how the pasted value looks.
- Assuming a number stored as text becomes a real number. Paste Values does not reliably convert text that looks numeric into a numeric value. A value such as 00125 may remain text, and keeping it as text may be important for an ID or postal code.
- Replacing formulas without keeping a backup. Once you save over formulas, their logic is gone from those cells. Undo may recover the formulas until you close or make further changes, but a saved backup is safer when the formulas may be needed again.
- Copying only part of a special formula range. Array formulas and dynamic spill results can have restrictions on editing individual cells. Select the full relevant range and paste to a separate destination if Excel will not let you replace only part of it.
Tips
- Use a separate destination for an audit-friendly copy. Leave the calculation cells unchanged and paste their values into another sheet or workbook. Add a label such as Fixed results and note the date if the timing matters.
- Know what is being frozen. Values are the results calculated at the time you copy. For a formula based on changing inputs, the pasted number will not recalculate later. If the workbook uses manual calculation, recalculate first with
F9on Windows, then copy the up-to-date results. - Keep formats when appearance matters. Values-only paste does not bring the source formatting. If you also need the original look, paste values first, then apply the destination’s number format or use a separate format-paste option. Check dates, percentages, and currency amounts, since the same underlying value can display differently under different formats.
- Use it for a formula-free handoff. A values-only copy is often easier to share when the recipient needs results but should not receive the calculation logic or links to other cells. Check for other workbook content, such as hidden sheets or named ranges, if you need to remove more than the formulas in the copied range.
- Be careful with errors. If a formula currently displays an error such as #DIV/0! or #N/A, Paste Values copies that error result too. Fix the underlying issue or decide whether the error is appropriate before freezing the range.
- Preserve identifiers deliberately. Account codes, product IDs, and postal codes may contain leading zeros. Excel can remove leading zeros from numeric values depending on how the cells are formatted. If these are identifiers, keep them as text or apply an appropriate format before distributing the file.
Troubleshooting
The destination still contains formulas. You may have chosen regular Paste instead of Paste Values. Undo, copy the source again, then use Home > Paste > Values. Confirm by selecting a pasted cell and checking the formula bar. If it begins with an equals sign, it is still a formula.
The pasted number looks different. The value may be correct while the destination’s number format is different. For example, a date serial may display as a plain number, or a decimal may display without currency formatting. Select the destination and choose the appropriate option in Home > Number Format. If you need to match the source appearance, apply the same number format rather than repeating a regular paste that could restore formulas.
Excel will not paste into the selected cells. Check whether the sheet is protected, the destination contains merged cells, or the copied and destination ranges have incompatible shapes. Try selecting a clear, unmerged destination with the same number of rows and columns. If the workbook is shared or restricted, confirm that you have edit access.
The paste option is unavailable or the shortcut does nothing. Make sure you copied cells in Excel and that the copied selection is still active; copying something else can replace the clipboard contents. Open the Home ribbon and expand the Paste menu. In Excel for the web, browser behavior can affect shortcuts, so use the ribbon or context menu instead. On Mac, prefer the ribbon’s Values option if a Windows shortcut does not apply.
A value that looks numeric will not calculate. It may be stored as text. Paste Values preserves the source content; it is not a text-to-number conversion tool. If the entry should be a true number, use Excel’s warning icon and choose Convert to Number when offered, or use Data > Text to Columns and complete the wizard with the appropriate settings. Do not convert codes with leading zeros if those zeros are meaningful.
A formula result is outdated or shows an error. Recalculate the source before copying. Press F9 on Windows to recalculate open workbooks, or check that the formula’s inputs and references are valid. Paste Values preserves the result Excel has calculated; it does not repair the formula or update a result that has not recalculated.
Frequently Asked Questions
Does Paste Values keep formulas?
No. It pastes the current result of a formula, not the formula itself. A number stays a number, a text result stays text, and an error result remains an error. The pasted result will not update when the original inputs change.
Can I replace formulas with their results in the same cells?
Yes. Copy the formula range, then use Paste Values on the same selected range. This replaces the formulas with their current results. Make a backup first if you might need the formulas again, because replacing them removes the calculation logic.
Will Paste Values copy colors, borders, or number formats?
No. Values-only paste is for cell contents, not the full formatting. The destination may keep its existing format, which can change how a number or date appears. Apply formatting separately if you need the pasted cells to look like the source.
Can I paste values between two workbooks?
Yes. Copy the source cells, switch to the destination workbook, select the top-left destination cell, and choose Paste Values. This transfers the results without carrying formulas that refer back to the source workbook. Check the destination formatting and confirm that the pasted values have the expected types.
Why did my leading zeros disappear?
Excel may interpret an entry such as 0048 as the number 48, or the destination may use a format that does not display leading zeros. Paste Values does not restore zeros that have already been lost. For identifiers that require them, store the entries as text or apply a suitable custom number format before copying.
Is there a one-step paste-values shortcut on Mac?
Mac shortcuts depend on the Excel build and keyboard settings, and Windows key combinations do not necessarily apply. The dependable method is to copy, select the destination, then choose Home > Paste > Values or use Paste Special from the Edit menu and select Values.
Related
- Excel Drop-Down List With Color: Setup and Formatting
- How to Lock an Excel Row at the Top While Scrolling
- Lock an Excel Workbook from Opening with a Password
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Calculate Dates in Excel From Today With Simple FormulasTo calculate a date a set number of days from today, enter =TODAY()+30 in any blank cell, such…
- Extract the First Word in Excel With a FormulaTo extract the first word from text in Excel, put the source text in A2 and enter =LEFT(TRIM(A2),FIND("…
- Excel Filter Shortcut: Ctrl+Shift+L and How to Use ItIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off for a selected…
- EDATE in Excel: Add Months, Not DaysEDATE in Excel moves a date by whole calendar months; it does not add a specified number of…
- Excel IF Greater Than: Formulas, Examples, and RulesIn Excel, use the greater-than operator > to test whether one number exceeds another; wrap the test in…
- Excel Conditional Formatting for Dates: Rules and FormulasTo color dates in Excel, select the date cells, then choose Home > Conditional Formatting > Highlight Cells…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.