Another way.

Select your cells to clean up.
Edit|goto|Special
click Constants
click ok
hit the delete key on the keyboard.

Don't select any cells that have labels you want to keep
(headers/instructions/etc).

scriblesvurt wrote:

Hello,

I have a large sheet that people enter data into each week. I want to
be able to hightlight a large area of the sheet and delete the data in
those selected cells, but not the formulars that are in some of the
cells.

Anyone know how I can do this?

Any help apreciated!

S

--
scriblesvurt
------------------------------------------------------------------------
scriblesvurt's Profile: http://www.excelforum.com/member.php...o&userid=24399
View this thread: http://www.excelforum.com/showthread...hreadid=380010

--

Dave Peterson