Question

How to remove formula in excel but keep the values

Answer 1

To remove formulas but keep values in Excel, use the Paste Special feature and select 'Values' to replace the formulas with their calculated values.

Step-by-step explanation:

To remove the formula but keep the values in Excel, you can use the Paste Special feature. Here's how:

1. Select the range of cells that contain the formulas you want to remove.
2. Right-click on the selected range and choose 'Copy' or press Ctrl+C.
3. Right-click on the same range again, choose 'Paste Special' or press Ctrl+Alt+V.
4. In the 'Paste Special' dialog box, select 'Values' and click on 'OK'.
5. The formulas will be replaced with their calculated values, while the original formulas will be removed from the cells.