Formulas in Worksheets

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

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


On Tue, 15 Nov 2005 14:19:02 -0800, "MusicMan"
<MusicMan@discussions.microsoft.com> wrote:

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