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

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

Constants will be selected.

EditClear Contents will keep formulas.


Gord Dibben Excel MVP

On Fri, 16 Dec 2005 09:52:03 -0800, "sdmccabe"
wrote:

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