How to save formulas on worksheets when creating new year sheet?
G Gord Dibben Nov 15, 2005 #2 CTRL + a to select all cells. F5>Special>Constants(tick the ones you want/don't want to select)>OK Edit>Clear>Contents. Formulas will remain ready for new data to be entered. Gord Dibben Excel MVP
CTRL + a to select all cells. F5>Special>Constants(tick the ones you want/don't want to select)>OK Edit>Clear>Contents. Formulas will remain ready for new data to be entered. Gord Dibben Excel MVP
