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

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
 
G

Gord Dibben

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

Locking Fomulas 2
Removing data entries but not formulas or formats 3
Change sheet name in formula 4
Average formula with a difference. 12
Filter with criteria! 4
if loop 2
copying row 2
how to change formula into value exel cells 1

Top