How can I clear all cell data EXCEPT formulas?

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
 
J

JulieD

Hi Gregg

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

Regards
JulieD
 
Top