how do I delete data from a worksheet without deleting the formul.

J

Jack

I am trying to clear just the data from a large sheet, and I want to keep the
formulas. This has to be possible, right?
 
G

Gord Dibben

Jack

Select all cells with CTRL + A(twice in 2003)

OR possibly you don't want to touch titles so select just the range to clear.

F5>Special>Constants. Check or uncheck what you want to find/keep and OK.

Edit>Clear>Contents.


Gord Dibben Excel MVP
 
Top