How to Remove Excel 2007 Formula and Keep Data

In this video tutorial we will show you how to remove excel formula and keep data.


In order to remove excel formula and keep the data, open Microsoft Excel. For example, in A1 cell type 5. In B1 cell type 6. In C1 cell type “=A1+B1”. Now, to remove formula and keep the data, select C1 cell and click “Copy” in the “Home” tab.

Copy cells data to the clipboard

Right-click on C1 cell and choose “Paste special”.

Choose Paste special

In the Paste Special pop-up window choose “Values” and press “ok”.

Choose Values option