How to Convert Formulas to Values in Excel: 8 Quick Methods

Method 1 – Use Paste Special Command to Convert Formulas to Values

Steps:

• Select cells (F5:F14).
• Press Ctrl+C to copy.

• Click Home from the ribbon.
• Select “Paste Special” from the “Paste” option.

• A new window named “Paste Special” will appear.
• Choose “Values” from the paste options and click OK to continue.

• Our selected data is converted to values now.
• You can check from the screenshot below by selecting a cell and looking at the formula bar you will see values showing instead of formulas.

Method 2 – Perform Paste as Values Option to Convert Formulas to Values

Steps:

• Choose cells from the dataset of your choice that you want to convert to values. We selected cells (F5:F14).
• Press Ctrl+C to copy.

• When the copy command is working, place your mouse cursor over the cells and click the right button of the mouse to appear options.
• From the “Paste Options” choose “Values”.

• All your copied cells consisting of formulas are converted into values.

Method 3 – Apply Keyboard Shortcuts to Convert Formulas to Values in Excel

3.1 Use Shift+F10+V Key

Steps:

• Choose cells (F5:F14) from the dataset.
• Press Ctrl+C to copy.

• After copying those cells, just press Shift+F10+V.

• We have successfully converted our formulas to values.

3.2 Press Alt+E+S+V Key

Steps:

• From the dataset choose cells (F5:F14) with formulas from the F
• Copy cells by pressing Ctrl+C.

• From the keyboard, holding the Alt button press E+S+V.

• Hit the enter button to activate the shortcuts.

• Check out the screenshot, you will see we have changed the format of cells to values.

3.3 Press Alt+H+V+S+V Key

Steps:

• Select cells (F5:F14)
• Copy the selected cell by pressing Ctrl+C.

• Holding the Alt button press H+V+S+V.
• Hit the Enter button to continue.

• This way, you will get our converted result within seconds.

Method 4 – Perform a Mouse Wriggle Trick to Convert Formulas to Values

Steps:

• Choose cells from the dataset to convert. We chose cell (F5:F14).

• Place the cursor over the selected line.
• A four-pointed icon will appear.
• When the icon appears hold the right button of the mouse and move towards any cell to get the output.

• Release your mouse button you will get some options in the new columns.
• Choose the “Copy Here as Values Only”.

• Your precious output is ready to convert formulas into values.

Method 5 – Use Notepad to Convert Formulas to Values in Excel

Steps:

• Select a range of cells (F5:F14).
• Press Ctrl+C.

• Open your notepad and paste the selected range.

• Get the values without formulas, as Notepad is not capable of reading formulas.
• Copy the output from the notepad.

• Paste the output in your excel workbook desired cells you want.

• Check the output from the following screenshot so that you will get only the values extracting formulas from the cells.

Method 6 – Edit a Formula to Convert Formulas to Values in Excel

Steps:

• Select a cell that has formulas in it.
• Press F2 to edit the formula.

• Hit the F9 button to convert to values.

• See we have our single-cell successfully converted to values without hesitation.

Method 7 – Utilize Power Query to Convert Formulas to Values in Excel

Steps:

• Select the whole dataset from the worksheet.
• Go to the “From Table/Range” from the “Data” tab.

• A new window will pop up confirming the range.
• Press OK to continue.

• From the “Power Query Editor” click the “Close & Load” to continue.

• A new worksheet will appear, converting all the formulas to values.
• Confirm the output by choosing a cell and checking the formula bar output.

Method 8 – Run a VBA Code to Convert Formulas to Values in Excel

Steps:

• In the worksheet press Alt+F11 to open the “Microsoft Visual Basic Applications”.

• Go to the “Module” from the “Insert” option.

• Copy the code from the following and then press “Run”.
• The code is-

Sub Convert_Formulas_to_Values()
Dim X As Range
Dim Cell As Range
Set X = Selection
For Each Cell In X
If Cell.HasFormula Then
Cell.Formula = Cell.Value
End If
Next Cell
End Sub

• After hitting the “Run” icon, go to your workbook and check the result by choosing a cell.

Things to Remember

• In method 6, I have shared conversion to formulas using F2 and F9 That method is applicable to a single cell. We can not select a whole range of data and convert formulas to values using the F2 and F9 keys. You have to change to values one by one cell.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

Convert Formulas to Values: Knowledge Hub

• Putting Result of a Formula in Another Cell in Excel 
• How to Convert Formula Result to Text String in Excel 
• How to Return Value of Cell Not Formula in Excel

<< Go Back to Excel Formulas | Learn Excel