An issued results table may need to remain fixed even while the calculation workbook continues changing. Create a separate snapshot rather than replacing formulas in the only working copy.

In desktop Excel for Windows, first confirm that the results represent the intended period and inputs. Resolve visible formula errors and establish whether any source data still needs updating. Freezing a result preserves its current value; it does not certify that the calculation was current or correct.

Work in a clearly named copy

Save a separate workbook for the snapshot and keep the calculation original. Select only the cells whose formulas should become fixed results, copy them, then use the Values option from Paste or Paste Special.

Microsoft states that this replaces the formulas. Immediate Undo can reverse an accidental replacement, but a preserved source workbook is a more deliberate recovery path than relying on an editing session remaining open.

Check representative cells in the formula bar. They should contain the intended values rather than the formulas you meant to remove. If the workbook uses array formulas, respect the full array range instead of replacing an arbitrary fragment.

Understand what the displayed number hides

A cell formatted to two decimal places can hold a more precise calculated value. Pasting values preserves the calculated value, not necessarily only the digits shown on screen. If a recipient requires rounded figures, settle and document that separate requirement before exporting.

Compare the snapshot’s totals and a few detailed rows with the calculation workbook. Keep useful labels such as the reporting period and units so the static numbers remain understandable.

Reopen the snapshot and confirm it behaves as intended. Removing selected formulas does not remove every other workbook feature or hidden item, so review the rest of the file for the intended handover. Store the snapshot and the calculation workbook under distinct names, with an obvious indication of which one should be used for future updates.

References: Microsoft: replacing formulas with results.