How can I clear all cell data EXCEPT formulas?

  • Thread starter Thread starter Gregg Hill
  • Start date Start date
G

Gregg Hill

Hello!

I have Excel 2003 and I would like to use a previous spreadsheet as a
template for the next year. I need to clear all data from the sheet but
preserve the formulas. If I highlight the sheet, click Edit>Clear, there is
no choice to clear everything except formulas.

Years ago, Lotus had a spreadsheet app called Lotus Improv. It was the
easiest spreadsheet program I have ever used. Microsoft would do well to use
some of its features, clearing cell contents but preserving formulas being
just one of them.

Gregg Hill
 
Hi Gregg

choose edit / go to / special
choose constants
click OK
and then press your delete key

Regards
JulieD
 

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

Alt codes 4
Clearing Cells 10
Clearing data 2
Increase Formula Cell Selection Based on Value 8
Clear cell numbers using a macro - Help! 2
Clear data but leave formulas 2
Ignoring Blank cells 9
formula help 4

Back
Top