Excel 2002

[Dean]

What is the quickest way to delete all the data but save the formulas?

 

[Gord Dibben]

Dean

CTRL + a(twice in 2003) to select all cells.

F5>Special>Constants>OK

Edit>Clear Contents.


Gord Dibben MS Excel MVP

 

[will A]

COPY, select another range or wks, EDIT, SPECIAL, FORMULA.