To remove a formula but keep its current result in Excel for Microsoft 365 on Windows, select the formula cells, press Ctrl+C, then Ctrl+Alt+V, press V, and press Enter. Choose Values in the Paste Special dialog if the shortcut sequence does not select it. To remove both the formula and its result, select the cells and press Delete instead.
What You’ll Need
- An Excel workbook with the formula cells you want to change. Save a copy first if the formulas are important, because replacing them with values is not easily reversible after you close the workbook.
- Permission to edit the worksheet. If it is protected, you may need the password or the person who manages the workbook to unlock it.
- A clear choice between keeping each formula’s current displayed result as a fixed value and clearing the cell completely. These actions have different outcomes.
Step-by-Step
- Decide what should remain. Use Paste Special > Values when you want to keep the result currently shown in the cell but stop it changing when its inputs change. For example, if a cell currently displays 240 because of a calculation, converting it to a value keeps 240 in the cell, not the calculation that produced it. Use Delete only when you want the cell contents gone.
- Save a recoverable copy. Before converting a large range or an important worksheet, save the workbook or make a duplicate using File > Save As. You can often undo immediately with Ctrl+Z, but undo history can be lost after closing the workbook or performing other operations. A copy is safer for significant changes.
- Select the formula cells. Click one cell to convert only that formula. For a continuous block, drag across the range or click its first cell, hold Shift, and click the last cell. To select separate cells or ranges, hold Ctrl while selecting them. Be careful not to include labels or input cells that you want to preserve.
- Copy the selection. Press Ctrl+C. Excel displays a moving border around the copied cells. Copying first is necessary because Paste Special uses the copied contents as its source; simply opening the Paste Special dialog without copying will not convert the formulas.
- Open Paste Special. Press Ctrl+Alt+V to open the Paste Special dialog. You can also use the ribbon: go to Home > Paste and choose the Paste Special option. If the dialog does not appear, check that Excel is the active window and that you are not editing text inside a cell.
- Choose Values. In the dialog, select Values, then choose OK. On many Windows installations, pressing V after opening the dialog selects the Values option; press Enter to confirm. The keyboard sequence is therefore Ctrl+C, Ctrl+Alt+V, V, Enter. If your dialog behaves differently, select the Values option with the mouse instead of relying on the letter key.
- Check the result. Click one of the converted cells and look at the formula bar. It should show a fixed value, such as a number, date, or text, rather than a formula beginning with an equals sign. The cell should still display the result it had at conversion. If it now shows a different appearance, check the cell’s number format and whether the original result depended on formatting.
- Confirm dependent calculations. Formulas elsewhere in the workbook may refer to the cells you converted. Those other formulas will generally keep working, but now they use the fixed values rather than recalculating the converted formulas. Check important totals, charts, and reports to make sure that freezing those inputs was intended.
On Excel for Mac, select and copy the cells with Command+C, then open Paste Special with Control+Command+V where that shortcut is available. Choose Values in the dialog and confirm. You can also use the Home tab’s Paste menu and choose the values-only paste option. Mac keyboard behavior can vary with keyboard settings and Excel releases, so using the menu is a dependable alternative. In Excel for the web, use Home > Paste and select the values-only option; browser shortcuts may intercept or change paste commands.
Common Mistakes
Pressing Delete when you meant to keep the result. The Delete key clears the selected cell contents, including a formula and its displayed result. It does not convert a formula to a value. If you need the result to stay, use Paste Special > Values.
Using ordinary paste. Copying a formula and pressing Ctrl+V normally pastes the formula, often adjusting its cell references for the new location. It does not remove the formula. Choose Values specifically, and verify the formula bar afterward.
Selecting the wrong cells or range. A broad selection can replace formulas, labels, or manually entered values you did not mean to change. Check the highlighted range before copying. If you selected an entire column accidentally, press Esc and make a more precise selection before continuing.
Assuming the result will keep updating. After conversion, the value is fixed at the time you paste it. If an input changes later, the converted cell will not recalculate. This is the purpose of the operation, but it can make a report or model stale if you expected it to remain live.
Tips
For a large conversion, try the process on one unimportant formula cell first. Confirm both the displayed result and the formula bar before applying it to a full range. If the test succeeds, repeat the same steps on the intended selection. This small check is especially useful when a workbook contains mixed formulas, constants, dates, or different number formats.
Values-only paste generally preserves the destination cells’ formatting because it pastes cell contents rather than the full formatting. For instance, a cell formatted as a date can continue to look like a date after its formula is replaced. If a number appears as a date or a date appears as a serial number, inspect the cell format from Home > Number; the underlying value may be correct even if its display format is not what you expect.
If you need a record of the original calculations, duplicate the worksheet before converting formulas. You can then keep one sheet with live formulas and another with fixed results. Give the sheets clear names so that readers know which one updates. Avoid copying a sheet as a substitute for checking the converted range: verify that the formulas on the intended sheet really became values.
For repeated one-off work, the keyboard sequence is quick once you know it: copy, open Paste Special, choose Values, and confirm. If you perform this action infrequently, the ribbon menu is less likely to cause confusion because it makes the paste choice visible. Do not use a macro just to convert a few cells; the built-in command is simpler and easier to review.
Troubleshooting
The Paste Special dialog does not open. Make sure a cell range has been copied and Excel has focus. Press Esc once or twice to leave cell-editing mode, select the range again, copy it, and retry Ctrl+Alt+V. If you are using a laptop or a customized keyboard, the shortcut may be affected by system settings. Use Home > Paste and open Paste Special from the menu instead.
The result disappeared or the cell is blank. You may have pressed Delete or chosen a clear option rather than Values. Immediately press Ctrl+Z to undo, provided you have not done other work that you need to keep. Then repeat the steps and explicitly select Values. If undo is no longer available, restore the saved copy or recover the original formula from another copy of the workbook.
The cell still contains a formula. The paste may have been a normal paste, or the wrong Paste Special option may have been selected. Select the cell and inspect the formula bar. If it begins with an equals sign, repeat the copy-and-paste-values process. If the cell is part of an array formula or a spilled dynamic-array result, Excel may prevent changing only one part. Select and handle the complete array or spill range; for a spill, you may need to copy the full displayed range to a separate area as values, then replace the source only after checking the result and dependencies.
The value looks wrong after conversion. Check the formula’s result before conversion and the cell’s number format afterward. A date, time, percentage, or currency can look different if its formatting was not retained or if you pasted into a differently formatted destination. Undo if necessary, then repeat the values-only paste over the original cells rather than into a differently formatted range. Also check whether the formula returned an error: Paste Special can preserve an error result as a fixed value too.
The shortcut behaves differently on Mac or in a browser. Use the application’s Paste menu instead of assuming a Windows key combination works everywhere. On Mac, use the Home tab’s Paste menu and choose Values if the shortcut does not open the expected dialog. In Excel for the web, browser or operating-system shortcuts can take precedence, so use the ribbon menu and confirm the outcome in the formula bar.
Frequently Asked Questions
What is the shortcut key to remove a formula but keep its result?
In Excel for Microsoft 365 on Windows, copy the selected cells with Ctrl+C, open Paste Special with Ctrl+Alt+V, choose Values with V, and press Enter. If the letter shortcut does not select Values in your dialog, select it manually.
How do I remove a formula and leave the cell empty?
Select the cell or range and press Delete. This clears the contents, so the calculated result disappears too. On some keyboards, the key may be labeled Backspace; use Excel’s clear command if that key starts editing the cell rather than clearing it.
Will the formula’s formatting disappear?
Usually not when you use Paste Special > Values on the original cells. The formula is replaced by its result while the existing cell formatting is generally retained. Check the number format if the result looks different, because formatting controls how values such as dates and percentages appear.
Can I use this shortcut on a whole worksheet?
You can convert a selected range, but avoid selecting the entire sheet unless you are certain every formula and value should be frozen. A worksheet-wide paste can affect far more cells than intended. Make a copy first, select the relevant area, and inspect the result before continuing.
Does converting a formula affect cells that refer to it?
It changes the converted cell from a calculation to a fixed result. Other formulas that refer to it can still calculate, but they use that fixed result and will not receive future updates from the original calculation. Review dependent totals, charts, and summaries if the workbook must stay current.
Can I undo the conversion?
Press Ctrl+Z soon after the paste to restore the formulas. Undo may not be available after closing the file or after Excel’s undo history has been cleared. For important work, save a copy before converting a large range.
Related
- How to Paste in Excel With Hidden Rows
- How to Paste in Excel Without Changing Cell Format
- Paste in Excel With Filtered Rows: Safe Methods
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Compare Two Lists in Excel to Find Unique ValuesTo find values in one Excel list that are missing from another, use FILTER with XMATCH; wrap the…
- Conditional Formatting in Excel: If-Then Color RulesYes. In Excel, select the cells you want to format, then choose Home > Conditional Formatting and create…
- Excel Time Card Formula: Track Hours and OvertimeFor a basic Excel time card, enter a start time in B2, an end time in C2, and…
- EDATE in Excel: Move Dates Forward by One Month EasilyTo move a date forward one calendar month in Excel, put the original date in A2 and enter…
- Approximate Match Lookup in Excel: Formulas and TipsFor a numeric approximate lookup in Excel, use an ascending threshold table and a formula that returns the…
- Excel Date Minus Date in Years? DATEDIF ExplainedThe direct answer: use =DATEDIF(start_date, end_date, "Y") to get whole years between two dates in Excel. For example,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.