Thread: Clear all?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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