ExcelBanter - Formulas in Worksheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formulas in Worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/55589-formulas-worksheets.html)

MusicMan

Formulas in Worksheets

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

Gord Dibben

Formulas in Worksheets

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?

All times are GMT +1. The time now is 05:38 PM.