Deleting Data

  • Thread starter Thread starter Joel
  • Start date Start date
J

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