CC

Assume you don't want to lose formulas.

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

F5SpecialConstants. Choose what you do or do want to select then OK your
way out.

Right-clickClear Contents.

Record a macro while you do this and assign to a button.

Or make it a Template as Paul suggests.


Gord Dibben Excel MVP


On Tue, 8 Feb 2005 12:01:02 -0800, "CC" wrote:

I have created an electronic order form and would like to make it reusable.
Is it possible to install a Reset or a Clear button, so the 'quantity'
columns will go back to 0?