Clear all?
Is there a way to clear all inputs to an existing workbook - everything but
the formulas? |
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? |
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 |
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? |
All times are GMT +1. The time now is 02:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com