| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear contents, keep formulas
I have a workbook with several sheets; they all interact with various
formulas and macros. This workbook will need to be "reset" at the end of the year. My question is: how can I essentially do a "Clear Contents" throughout the workbook, and keep all the formulas intact? Thanks for the help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Clear contents, keep formulas
Edit Goto... Special Constants
Edit Clear Contents -- Gary''s Student - gsnu200751 "billinr" wrote: I have a workbook with several sheets; they all interact with various formulas and macros. This workbook will need to be "reset" at the end of the year. My question is: how can I essentially do a "Clear Contents" throughout the workbook, and keep all the formulas intact? Thanks for the help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Clear contents, keep formulas
Thank you!!
"Gary''s Student" wrote: Edit Goto... Special Constants Edit Clear Contents -- Gary''s Student - gsnu200751 "billinr" wrote: I have a workbook with several sheets; they all interact with various formulas and macros. This workbook will need to be "reset" at the end of the year. My question is: how can I essentially do a "Clear Contents" throughout the workbook, and keep all the formulas intact? Thanks for the help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clear Contents Of Cells Where Value = 0 | Excel Worksheet Functions | |||
| How do I clear contents from a spreadsheet but not the formulas | Excel Discussion (Misc queries) | |||
| How do I clear contents in my workbook w/o loosing my formulas? | Excel Worksheet Functions | |||
| excel command to clear contents except 2 formulas | Excel Discussion (Misc queries) | |||
| Clear contents but leave formulas in Excel | New Users to Excel | |||
Linear Mode
