| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting data but keep formulas/formatting.
I've got a wookbook with 16 sheets. All of my data is on the first sheet. The
other 15 have formuals to automatically count, sum, average, add to a chart etc etc from the first sheet. How do I start over for the new year? I want to start another wookbook with all the same formulas, formatting and pivot tables minus last years data. Thanks, and PLEASE keep it simple. TT -- Its better to remain silent and be thought a fool than open ones mouth and remove all doubt. Creditied to Mark Twain. So I guess I''''ve removed all doubt. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting worksheet breaks my formulas | Excel Discussion (Misc queries) | |||
| Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
| deleting values in a worksheet without deleting the formulas | Excel Worksheet Functions | |||
| Deleting data in cells while saving formatting & formulas | New Users to Excel | |||
| Excel is Deleting My Formulas?? | Excel Discussion (Misc queries) | |||
Threaded Mode
