Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear all?
Is there a way to clear all inputs to an existing workbook - everything but
the formulas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear all?
sdmccabe, one way, ctrl a to select all cells, then edit, goto, special,
check constants, OK, delete -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "sdmccabe" wrote in message ... Is there a way to clear all inputs to an existing workbook - everything but the formulas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear all?
Select the range you want to clean up--include as many formula cells as you
want. Then edit|goto|special check Constants click ok hit the delete key on the keyboard. (You may have constants that you want to keep--headers/descriptions/instructions.) sdmccabe wrote: Is there a way to clear all inputs to an existing workbook - everything but the formulas? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear all?
CTRL + a(twice in Ver. 2003) to select all cells.
F5SpecialConstants. De-select the type you want to keep, like Text for titles and OK your way out. Constants will be selected. EditClear Contents will keep formulas. Gord Dibben Excel MVP On Fri, 16 Dec 2005 09:52:03 -0800, "sdmccabe" wrote: Is there a way to clear all inputs to an existing workbook - everything but the formulas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto clear when qualification is met | Excel Discussion (Misc queries) | |||
Can't Clear Print Area | Excel Discussion (Misc queries) | |||
Macro to make all checkboxes false and clear all comboxes | Excel Discussion (Misc queries) | |||
Using a Macro to clear out check box seletions | Excel Worksheet Functions | |||
need to clear data references in pivot table report | Charts and Charting in Excel |