How do I convert an entire column of formulas to values in Excel?

Select the column, press Ctrl+C, right-click the same selection, choose Paste Special > Values, and click OK. All formulas are replaced with their current results.

Will freezing a formula break any other formulas that depend on it?

No - formulas in other cells that reference a frozen cell will simply use the static value going forward instead of a calculated result.

Is there a keyboard shortcut to paste values only in Excel?

After copying, press Ctrl+Alt+V to open Paste Special, then press V and Enter to select Values quickly without using the mouse.

Freeze Excel Formula to Its Current Value

For one reason or the other, you may need to lock the results of a cell’s formula permanently into its current value. There are two ways to accomplish this, quickly: Approach 1: If you are dealing wit...

For one reason or the other, you may need to lock the results of a cell’s formula permanently into its current value. There are two ways to accomplish this, quickly: Approach 1: If you are dealing with just a few cells: Step 1: Select the cells and press F2 to get into formula editing mode Step 2: Press F9 to automatically calculate the formula and return the result Step 3: Press Enter to step out of the cell and end the freeze process Approach 2: If you are dealing with a significant number of cells: Step 1: Select the range of cells Step 2: Copy the cells (Ctrl + C) Step 3: Go to Paste Special, and paste the cells over the original range as Values only.

Convert Excel Formulas to Static Values: Two Fast Methods

Frequently Asked Questions