How to Convert Formulas to Values in Excel

Sometimes you want your cells to have just the values instead of the formulas. In this post, we will learn how to copy the values, remove formulas and paste just the values into cells. Here is how to convert formulas to their current values.

1. Select the range of cells consisting formulas that you want to copy the values from. 

2. Use the keyboard shortcut key ( CTRL + C ) or the copy button as you see in the picture below to copy the information.

3. Right click on the cells that you want to paste that information and select Paste / Special Values. 

Each of the formula you selected and pasted is replaced with the latest values. The cells will no longer be able to perform the equations