Table of Contents
Excel is a powerful tool that allows users to manipulate and analyze data in a variety of ways. One of its most useful features is the ability to remove formulas but keep the value. This can be especially helpful when trying to make a permanent copy of a spreadsheet without including the formulas used to calculate the values. Removing the formulas can also be helpful when sharing a spreadsheet with someone who does not have the same version of Excel as you. Having the ability to remove formulas but keep the value makes Excel an invaluable tool for many businesses and individuals.
Often you may want to remove formulas from cells in Excel but keep the values in the cells.
Fortunately this is easy to do by using the Paste Values function in Excel.
The following example shows how to use this function in practice.
Example: How to Remove Formula But Keep Value in Excel
Suppose we have the following dataset that contains information about sales of various products at some company:
Each cell in the Revenue column contains a formula that multiplies the Sales by the Price.
For example, cell D2 contains the formula =B2*C2.
Suppose we would like to remove the formulas from each cell in column D but keep the values.
To do so, we can first highlight the cell range D2:D9.
With this cell range highlighted, press Ctrl + C to copy each of the values in the range.
Next, right click on cell D2 and then click the option called Paste Values:
All of the values from the Revenue column will now be pasted over the existing values and the formulas will be removed:
Notice that each of the values in the cells of the Revenue column is the same as before but there are no formulas in any of the cells.