| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas in Worksheets
How to save formulas on worksheets when creating new year sheet?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shortcut for copying formulas referencing different worksheets | Excel Discussion (Misc queries) | |||
| apply cell names to formulas in multiple worksheets | Excel Worksheet Functions | |||
| Enabling Formulas Between Two Worksheets | Links and Linking in Excel | |||
| Copy worksheets with formulas between different workbooks | Excel Discussion (Misc queries) | |||
| Excel 2002 - copying formulas across worksheets | Excel Discussion (Misc queries) | |||
Linear Mode
