Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

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!

Re: Clearing formulae without clearing data

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...

Cory

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

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

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? :)

Re: Clearing formulae without clearing data

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

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.