Clear all?

S

sdmccabe

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

Paul B

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
 
D

Dave Peterson

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.)
 
G

Gord Dibben

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

F5>Special>Constants. De-select the type you want to keep, like Text for
titles and OK your way out.

Constants will be selected.

Edit>Clear Contents will keep formulas.


Gord Dibben Excel MVP
 
Top