Final answer:
To remove all formulas in Excel and keep values, select the cells with the formulas, copy them, and use 'Paste Special' to paste as values. This replaces the formulas with their current values, leaving you with a static version of your data.
Step-by-step explanation:
To remove all formulas and keep values in .Excel, you'll need to convert all formula cells to their static value counterparts. Here's how you can do this:Select the cells that contain the formulas you want to convert to values.Copy those cells (Ctrl + C for Windows or Cmd + C for Mac)Right-click on the selected cells and choose 'Paste Special' from the context menu.
In the Paste Special dialog box, choose 'Values' and click 'OK'. This action pastes the current values of the formulas into the cells, effectively removing the formulas and leaving just the values.Note that once you perform this action, Excel, you'll need to convert all formula cells to their static value counterparts. Here's how you can do this:Select the cells that contain the formulas you want to convert to values.Copy those cells (Ctrl + C for Windows or Cmd + C for Mac)you will not be able to recover the original formulas unless you undo immediately or have a prior version of your document saved.