remove the cells contents (data) without removing formulas Excel 2

  • Thread starter Thread starter onebigred51
  • Start date Start date
O

onebigred51

I need to remove all the data in a woorksheet whithout removing the formulas
in Exel 2007. I want to use the woorksheet for a new year
 
You may want to preserve titles text as well.

Uncheck the option "Text"


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change sheet name in formula 4
Average formula with a difference. 12
Filter with criteria! 4
Locking Fomulas 2
Formula text in woorksheet cell 2
Excel Formula Help! 2
How to use if analysis 2
if loop 2

Back
Top