Subscribe!

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:

  1. Delete Duplicate Rows Using Advanced Filter – Excel There are many ways to remove duplicate rows in Excel,...
  2. Paste Special – Transpose Excel Transpose...
  3. Duplicates – Finding and Removing in Excel There are many occasions when you may need to remove...
  4. Removing Macros from a Workbook Q: How do I remove all the macros from my...
  5. Removing Characters from a String in Excel It is often necessary to replace characters within a string...

This entry was posted on Tuesday, December 2nd, 2008 at 1:48 pm and is filed under Excel Quick Tricks. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.