software

Is there a way to clear all inputs to an existing workbook - everything but
the formulas?

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 amp; 2003

quot;sdmccabequot; gt; wrote in message
...
gt; Is there a way to clear all inputs to an existing workbook - everything
gt; but
gt; the formulas?
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:
gt;
gt; Is there a way to clear all inputs to an existing workbook - everything but
gt; the formulas?

--

Dave Peterson

CTRL a(twice in Ver. 2003) to select all cells.

F5gt;Specialgt;Constants. De-select the type you want to keep, like Text for
titles and OK your way out.

Constants will be selected.

Editgt;Clear Contents will keep formulas.Gord Dibben Excel MVP

On Fri, 16 Dec 2005 09:52:03 -0800, quot;sdmccabequot;
gt; wrote:

gt;Is there a way to clear all inputs to an existing workbook - everything but
gt;the formulas?