Deleting data in cells while saving formatting & formulas

[greymann19]

I have severl large woorkbooks/sheets that I have to reuse each month. Is there a quick and easy way to remove cell data but keep the cell formatting and formulas intact? The only way I've figured out so far is to use the backspace key in every individual cell.

[JE McGimpsey]

one way:

Edit/Goto/Special/Constants, Click OK. Type Del.

In article <[email protected]>,
greymann19 <[email protected]>
wrote:

> I have severl large woorkbooks/sheets that I have to reuse each month.
> Is there a quick and easy way to remove cell data but keep the cell
> formatting and formulas intact? The only way I've figured out so far is
> to use the backspace key in every individual cell.