There are times when it is useful to remove all formulas from a worksheet. It may simplify a sort or perhaps you do not want to show the world your method of calculation. The quickest and easiest method of doing this is using paste special.
Select the cells or entire worksheet you would like to remove the formulas from. Once highlighted, right click and select copy. Right click again (in the same highlighted area and choose “paste special”. In the paste special menu select values and then choose okay. All formulas are now removed.
Joseph Harris
Excel Help
Analyst Help
Related posts:
- Delete Duplicate Rows Using Advanced Filter - Excel There are many ways to remove duplicate rows in Excel,...
- Paste Special - Transpose Excel Transpose...
- Duplicates - Finding and Removing in Excel There are many occasions when you may need to remove...
- Removing Macros from a Workbook Q: How do I remove all the macros from my...
- Removing Characters from a String in Excel It is often necessary to replace characters within a string...