Deleting data in cells while saving formatting & formulas
 

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.


--
greymann19
------------------------------------------------------------------------
greymann19's Profile: http://www.excelforum.com/member.php...o&userid=27977
View this thread: http://www.excelforum.com/showthread...hreadid=474860

one way:

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

In article ,
greymann19
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.