OmniDocRemove Formula Formatting in Excel
Learn how to strip formulas from Excel cells while keeping the values you see, with steps, pre-checks and a way to verify the result.
You have a spreadsheet full of formulas, and you need to send it to someone who should not see the calculations, or you need a fixed snapshot of the numbers at a certain date. Maybe a report template keeps recalculating when it should be frozen, or a shared file breaks because the formulas point to a sheet that no longer exists. In each case, you want the numbers you see on screen to stay exactly as they are, without the formulas behind them.
The fix in Excel is to replace each formula with its current result. You do this by copying the cells and pasting them back as values. The displayed numbers stay the same, but the cells no longer calculate. This guide covers that method, a second approach that keeps your original sheet untouched, and the checks that catch problems such as broken links or changed date formats.
How do you remove formulas in Excel and keep the values? The short answer
Copy the cells that contain formulas, then paste them back using the option that pastes values only, so each formula becomes its current result.
| Your situation | What to do | Why |
|---|---|---|
| You want to freeze one range in the same sheet | Copy the range, then paste values only over the same cells | The formulas are replaced in place, and nothing else moves |
| You want to keep the original formulas for later | Copy the range and paste values into a new sheet or file | The source sheet keeps its live calculations |
| The whole workbook must be a static snapshot | Select all cells on each sheet, copy, and paste values only | Every formula becomes a fixed result, including totals |
| Some formulas depend on other sheets | Check cross-sheet references before pasting | Those results must still be correct when they become fixed values |
| The file will be shared as a read-only record | Save a separate copy after conversion | Your working file stays editable with formulas |
Before you start
Preparing a few things first prevents a common mistakes, which are overwriting data you still need and freezing a wrong number.
- Save a backup copy. Pasting values cannot be undone once you save and close the file. A copy lets you return to the live formulas if you find an error later.
- Confirm which cells contain formulas. Click a cell and read the formula bar. Only cells that show a formula will change. Constants you typed by hand stay the same.
- Look for references to other sheets or files. A formula such as one that pulls from another tab will become a fixed number. Make sure that number is the one you want to keep.
- Note any totals or summary cells. These often depend on many formulas. Write down their current values so you can compare them after the change.
- Decide where the result should live. Replacing formulas in place is quick, but a separate sheet is safer if you may need the calculations again.
Converting formulas to values in Excel, step by step
The steps below cover the in-place method first, followed by the separate-sheet option. Use whichever matches your situation from the table above.
- Save a backup. Use File and then Save As to create a copy with a new name, such as "report-values-only.xlsx". Work in the copy so your original keeps its formulas.
- Select the cells you want to freeze. Click and drag over the range, or click a corner cell and use Shift with an arrow key to extend the selection. Include every column that holds formulas.
- Copy the selection. Use the copy command or press Ctrl+C on Windows or Command+C on a Mac. Excel marks the range with a moving border, which means it is ready to paste.
- Open the paste options for values. Right-click the top-left cell of the range where you want the values, then look for the paste option that shows only values. The icon usually displays the numbers "123" or similar. Choose that option instead of the default paste.
- Check the formula bar. Click a few cells that held formulas. The bar should now show the number or text, not an equals sign and calculation.
- Repeat for other ranges or sheets. If the workbook has several sheets with formulas, repeat the process on each one. Pasting values on one sheet does not change the others.
- Save the file under its new name. Keep the original backup in place, and save the converted file as a separate version so you can tell them apart.
If you want to keep the formulas in the original sheet, copy the range and use the same values-only paste option in a new sheet or a new workbook. The source remains live, and the new sheet holds the frozen results.
Check the result
Once the values are pasted, compare them with what you had before. Small differences often come from settings that changed during the paste, not from the numbers themselves.
| Check | How to see it | If it's wrong |
|---|---|---|
| Formulas are gone | Click cells that used to hold formulas and read the formula bar | Repeat the values-only paste on the missed range |
| Totals match | Compare key totals with the values you wrote down earlier | Look for a range you did not copy, or a formula that depended on a hidden row |
| Dates still look like dates | Check cells that show dates for numeric serial numbers | Reapply the date format to those cells |
| Number formats and decimals match | Compare how decimals and currency symbols display | Reapply the number format to the affected columns |
| No broken references remain | Scan for error values such as #REF! in cells that were calculated | Restore the formula from your backup and fix the source before converting |
| Column widths are readable | Look for cells showing ### after the change | Widen the columns or adjust the font size |
Treat the frozen numbers as a snapshot. If the source data changes later, the values will not update, so note the date you made the conversion in the file or in its title.
❓ FAQ
1. Will pasting values delete my formatting?
It can change how some cells look. Plain values paste may not carry every display setting, so check number formats, dates and column widths using the table above. Reapply formatting to any cells that changed.
2. Can I undo the change after saving?
Not reliably. Once you save and close the workbook, the formulas are gone from that file. This is why saving a backup copy before you begin matters.
3. What if a formula refers to another sheet?
The cell will keep the result it showed at the moment you paste, and it will stop updating. Confirm that the value is still correct before you freeze it, because it will not change if the source sheet changes later.
4. Is there a way to remove formulas from a file without opening it in Excel?
Converting formulas usually means working in the spreadsheet itself so you can see the results before they become fixed. If you use a different spreadsheet editor, use its paste-as-values option in the same way and run the same checks afterward.
📝 Summary
Removing formulas in Excel comes down to copying the cells and pasting them back as values, which keeps the numbers you see and stops the calculations. Save a backup first, and keep a separate copy if you may need the formulas later. Then compare totals, dates and number formats to confirm the frozen results are correct.
