MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Clearing formulae without clearing data

Posted by Sara on July 18, 2001 10:06 AM

Is there a way to clear all the formulae from a worksheet, without clearing the contents of the cells? -

**** note that the actual data is no longer dependant on the formulae.. so its not going to give me #REF errors. I just need to get rid of all the underlying formulae if there is a way.

Thanks in advance!

Posted by Cory on July 18, 2001 10:14 AM

Sure 'nuf! Just highlight the cells containing the formulas, copy them, then Paste Special(Values) right back into the same cells...


Posted by Sara on July 18, 2001 11:35 AM

Is there a way to do it a whole worksheet at a time?

Cory - Thanks for this suggestion. The only problem is that I'm dealing with some large files.. (45,000 lines).. and I'm also wanting to remove any formulas that are hiding in empty cells.

Any other thoughts? :)

Posted by Bob on July 18, 2001 1:09 PM

Hit CTRL - A (This will select everything), right click
paste special values....