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

Remove Identical words 0
Filter with criteria! 1
Excel found unreadable content in file error. 0
Formula text in woorksheet cell 2
Remove punctuation mark, Split cells & average accross column 4
Remove title bar and phase bar by default on swimlane 0
Removing data entries but not formulas or formats 3
Excel Formula Help! 2

Top