View Single Post
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

Jack

Select all cells with CTRL + A(twice in 2003)

OR possibly you don't want to touch titles so select just the range to clear.

F5SpecialConstants. Check or uncheck what you want to find/keep and OK.

EditClearContents.


Gord Dibben Excel MVP

On Wed, 16 Feb 2005 16:41:03 -0800, "Jack"
wrote:

I am trying to clear just the data from a large sheet, and I want to keep the
formulas. This has to be possible, right?