Freeze Values in Excel: Turn Formulas Into Fixed Results

To freeze values in Excel, select the formula cells, copy them, then choose Home > Paste > Paste Values to replace the formulas with their current results. The numbers or text stay in the cells, but they no longer update when their inputs change. This is different from Freeze Panes, which keeps rows or columns visible while you scroll.

What You’ll Need

A workbook open in Excel. These steps are for Microsoft Excel for Microsoft 365 on Windows; the same Paste Values command is available in current desktop versions.
The cells whose formulas or linked results you want to make permanent. You can select one cell, a range, or a whole column of results.
A saved copy of the workbook if you may need to restore the formulas later. Replacing formulas with values is not something you can reverse after closing and reopening the file.

Step-by-Step

Check what you are about to replace. Click a cell in the target range and look at the formula bar above the worksheet. If it begins with an equals sign, the cell contains a formula. Make sure you intend to remove that formula, rather than merely stop the sheet from scrolling. If the results depend on data that may still change, consider saving a separate copy first.
Update the results before freezing them. Paste Values keeps the result Excel currently has, not a promise to calculate it again later. If the workbook uses automatic calculation, changing an input will normally update dependent formulas. If calculation is set to Manual, press F9 on Windows to recalculate before proceeding. You can check the setting under Formulas > Calculation Options; choose Automatic if that is appropriate for the workbook. F9 recalculates formulas, so check that the displayed results are the ones you want to preserve.
Select the cells to convert. Click and drag across a contiguous range, or click the first cell, hold Shift, and click the last cell. To select a full column, click its letter at the top; be aware that this includes empty cells and any other content in that column. For separate, non-adjacent ranges, hold Ctrl while selecting additional ranges. If you only need to freeze a portion of a formula column, select just those cells rather than the whole column.
Copy the selection. Press Ctrl+C, or choose Home > Copy. A moving border appears around the copied cells. Copying is necessary because Paste Values pastes the copied results back over the selected cells. Do not press Delete: that would clear the cells instead of keeping their current results.
Paste the values over the same cells. Keep the range selected and choose Home > Paste > Paste Values. In the Paste dropdown, select the Values option, commonly shown with a 123 icon. This writes each cell’s current result into its existing position. It removes formulas from the selected cells but normally leaves the destination cells’ existing formatting in place. Avoid choosing the regular Paste command, which would copy formulas as well as other cell contents.
Use the keyboard route if you prefer. After copying on Windows, press Ctrl+Alt+V to open Paste Special, choose Values, and confirm with Enter. Depending on the dialog shown by your Excel build, you may also be able to press V to select Values before pressing Enter. On a Mac, use the Home tab’s Paste dropdown and choose Values; the Paste Special dialog can also be opened with Control+Command+V in Excel for Mac, then select Values. Keyboard shortcuts can vary with keyboard layout, so the ribbon command is a reliable alternative.
Confirm that the conversion worked. Click one of the changed cells and inspect the formula bar. A formula cell should now show its result as a constant—for example, a number, date, or text—instead of a formula beginning with an equals sign. Change an input cell only if it is safe to do so; the pasted value should remain unchanged. Check a few cells across the range, especially if it contains different kinds of formulas or blank cells.

You can also paste results into a different location: copy the formula range, select the destination’s top-left cell, and choose Home > Paste > Paste Values. This creates a values-only copy while preserving the original formulas. It is often the safer approach when you want to share a report or keep an archive but may still need the working calculations. Ensure the destination area is large enough and does not contain information you need to keep.

Common Mistakes

Confusing values with Freeze Panes. View > Freeze Panes locks rows or columns in view as you scroll; it does not change formulas. Paste Values is the command for turning formula results into fixed cell contents.
Using ordinary Paste. Ctrl+V usually carries formulas into the pasted cells. If the source and destination are the same, it may appear that nothing changed. Choose the Values option specifically, then check the formula bar.
Freezing before recalculating. In Manual calculation mode, a formula may show an older result. Once you paste values, that old result becomes the permanent content of the cell. Recalculate and inspect key totals first.
Overwriting more than intended. Selecting an entire column can include labels, existing values, or cells below the working table. Check the highlighted selection and use a precise range when practical. Pasting blanks from the copied range can also replace content in corresponding destination cells.
Assuming formatting is part of the value. Paste Values transfers results, not the source cell’s formatting. Dates and percentages can therefore look different in a differently formatted destination. When pasting over the original range, its existing formats generally remain; when pasting elsewhere, check the destination format.

Tips

Keep a formula version. Save a new copy before converting an important model, or paste values into a separate report sheet. This gives you a way to inspect or revise the original calculations later.
Use values-only copies for sharing. A values-only report can avoid exposing formulas or dependences on other sheets and linked workbooks. Check the results and remove any confidential information separately; Paste Values is not a privacy or security feature.
Be careful with dates and times. Excel stores dates and times as numbers, while cell formatting makes them appear as calendar dates or clock times. Paste Values preserves the underlying result, but a destination with General formatting may show a serial number. Apply an appropriate date or time format if needed.
Consider formulas that depend on changing data. Freezing a cell stops that cell from recalculating, but formulas elsewhere in the workbook may still refer to it and continue to calculate. Review downstream totals and charts if the workbook is intended to represent a fixed snapshot.
Use Paste Values & Number Formatting only when needed. Excel offers a paste option that includes both values and number formats. Choose it when pasting to a different area and you want the source’s date, currency, or percentage appearance as well as the result. For a same-range conversion, the Values option is usually sufficient.
Convert only finished results. A useful time to freeze values is after completing a monthly report, importing a final calculation, or preparing a fixed snapshot for review. Avoid converting intermediate calculations in a model that still needs updates.

Troubleshooting

The cells still show formulas. The regular Paste command may have been used. Copy the range again and choose Home > Paste > Paste Values. Then click a cell and check the formula bar; the displayed result alone cannot prove that a formula was removed.
The pasted dates appear as numbers. The date value may have pasted correctly but the destination format is General. Select the cells and apply a date format from Home > Number Format, or paste values back into the original cells where the date formatting already exists.
The result looks old or incorrect. Undo immediately with Ctrl+Z if the operation is still available, recalculate with F9, inspect the inputs and calculation setting, then repeat the paste. If the workbook was closed after the conversion, undo may no longer be available; restore a saved formula version or use an earlier backup.
Paste Values is unavailable or disabled. Copy the cells first, then open the Paste dropdown. If you are editing a cell, press Esc to leave edit mode and copy the range again. In a protected worksheet, editing may be restricted; ask the workbook owner to allow changes or unprotect the sheet if you are authorized to do so.
Only some cells changed. Check that the copied range and destination selection have the same shape and that the full intended range was highlighted. Repeat the operation on the missing cells. If multiple areas were selected, try converting each contiguous range separately to make it easier to verify.
The workbook recalculates but a frozen cell does not change. That is expected: the formula in that cell has been replaced by a constant. To restore a live result, retrieve the original formula from a backup, version history, or another equivalent cell; Excel cannot infer the formula from its result.

Frequently Asked Questions

Does freezing values delete the formulas?
Yes. When you paste values over formula cells, the formulas in those selected cells are replaced by their current results. Formulas in cells you did not select are not removed, even if they refer to the converted cells.

Can I freeze values without changing the original formulas?
Yes. Copy the formula cells to another range or worksheet and choose Paste Values at the destination. The original cells remain formula-driven, while the copied cells hold fixed results.

Will the formatting stay the same?
When you paste values over the same cells, the cells’ existing formatting generally remains. If you paste into a differently formatted destination, the destination’s formatting is used, so a date or percentage may look different. Use the Values & Number Formatting option if you want to bring over number formats too.

Can I freeze values in Excel for the web?
Yes. Select and copy the cells, then use the Paste dropdown on the Home tab and choose Values if that option is available in your current web interface. If the ribbon layout differs, use the available Paste Special or values-only paste option. The desktop shortcut sequences described above are for Excel on Windows and Mac, not a guarantee for every browser.

Can I freeze a formula result that changes every time the workbook recalculates?
Yes. First calculate the workbook and confirm the current displayed result is the one you want to keep, then paste values over that cell. The result will no longer update. If you need a new snapshot later, you must calculate again and repeat the conversion or keep a separate formula-driven copy.

Is freezing values the same as locking a cell?
No. Pasting values removes a formula from the selected cell. Locking a cell is a protection setting that can prevent editing when the worksheet is protected; it does not turn a formula into a fixed result.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.