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.
Gord Dibben Excel MVP
On Wed, 16 Feb 2005 16:41:03 -0800, "Jack"
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?