CTRL + a to select all cells.

F5SpecialConstants(tick the ones you want/don't want to select)OK

EditClearContents.

Formulas will remain ready for new data to be entered.


Gord Dibben Excel MVP


On Tue, 15 Nov 2005 14:19:02 -0800, "MusicMan"
wrote:

How to save formulas on worksheets when creating new year sheet?