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
 
Back
Top