Deleting Data

[Joel]

I could really use some help here. I need to delete data without deleting
formulas. I don't want to have to do it on a cell by cell basis. I would
like to be able to select the entire sheet and then click a button like
"clear contents" but leave all formulas and formats.

Thanks

Joel
(e-mail address removed)

 

[Nick Hodge]

Joel

Select a cell on the sheet and go to Edit>Go to...>Special>Constants and
press the delete button

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Gord Dibben]

Joel

CRTL + A then F5>Special>Constants(choose what type you want to find)>OK

With those highlighted, right-click>clear contents.

Gord Dibben Excel MVP