How to Remove Formulas in Excel but Keep the Values

How to Freeze All Formulas to Values Online

1. Open the free Convert Formulas to Values tool and drop in your .xlsx, .xlsm, or .xls workbook. Processing is fully local — the file is never uploaded.
2. Click Convert formulas to values — every sheet is scanned cell by cell for formulas.
3. Read the report: for each sheet it lists the formula count and how many cells will go blank because they have no cached value.
4. If an amber warning appears, open the file in Excel or the online editor, let it calculate, save once, then run the tool again.
5. Download the result as your-file-name-values-only.xlsx — fixed values only, with no formulas left.

The cached value is what Excel last saved into the file. A formula that was pasted in but never recalculated and saved has no cache — converting it would produce a blank. The report counts those cells explicitly instead of silently blanking them.

• Convert Excel Formulas to ValuesThe free online tool used in the steps above.

What Happens to Each Cell

Inside an .xlsx file, a formula cell stores two things: the formula itself (f) and the cached value (v) that Excel calculated the last time the file was saved. The conversion deletes the formula and keeps the cached value — ordinary cells are never touched:

Because the formula is gone rather than hidden, nothing recalculates afterwards: changing an input cell no longer updates the results. That is the point — the numbers are frozen exactly as they were at conversion time.

Manual Method: Paste Special → Values

1. Select the range with formulas and copy it (Ctrl+C).
2. Right-click the same range → Paste Special → Values (or press Ctrl+Alt+V, then V).
3. Repeat for every range on every sheet.

The manual route has two failure modes. First, it is per-range, per-sheet: a 10-sheet workbook means 10+ careful selections, and missing one hidden column of formulas is common. Second, pasting values over array formulas (dynamic arrays or legacy CSE formulas) can scatter #VALUE! or refuse the paste — those ranges need care no matter which method you use.

When Removing Formulas Is the Right Call

• Handing a file to someone who only needs the numbers — no recalculating, no broken-reference warnings on their machine.
• Stopping #REF! chains: a sheet rename, row deletion, or column move breaks every reference pointing at it; frozen values cannot break.
• Sending data to another system — imports, uploads, and CSV exports want values, not formulas.
• Keeping a snapshot: a values-only copy is a permanent record of “what the numbers were that day”.
• Sharing calculations without sharing the method — the formula is your intellectual property; the value is the deliverable.

After freezing, two follow-ups cover most downstream needs: if the values were built from text-formatted numbers, a text-to-numbers pass makes them computable again; and a values-only workbook is also the natural moment to slim the file down — unused formula machinery and cached chains are gone.

• Convert Text to Numbers in ExcelFix “number stored as text” cells after freezing.
• Reduce Excel File SizeStrip redundant parts without touching data or formatting.