Forum Discussion
Morwest
Jun 07, 2023Copper Contributor
deleting excel formulas
i have made a doc using info from several sources cut and pasted, and some of the auto sum functions won't work correctly. is there a way to disablee all formulas from an excel doc before starting wo...
NikolinoDE
Jun 08, 2023Platinum Contributor
There are a few ways to disable or remove formulas in an Excel document:
- Copy and Paste Values: Select the range of cells containing the formulas, right-click, and choose "Copy". Then, right-click again and choose "Paste Special". In the Paste Special dialog box, select "Values" and click "OK". This will replace the formulas with their calculated values.
- Find and Replace: Press "Ctrl + H" to open the Find and Replace dialog box. In the "Find what" field, enter "=" (without quotes) to search for all formulas. Leave the "Replace with" field blank. Click "Replace All" to remove all formulas.
- Convert to Values: Select the range of cells containing formulas, go to the "Home" tab, click on the "Paste" dropdown arrow in the Clipboard group, and choose "Paste Values". This will convert the formulas to their calculated values.
By using any of these methods, you can disable or remove formulas from an Excel document and work with the resulting static values. Remember to save a backup copy of the original document before making any changes.
I hope it helps!