reset cells to 0 all at once
 

I have a sheet that requires me to clear all the cells to continue. My cell
are A2 to C30. Is there a button or something I can have to clear them all at
once?

reset cells to 0 all at once
 

Do you want have a zero in each cell?
Type A2:C30 in the name box (above column A)
type 0 and press ctrl + enter

If you want to clear the cells of content type
A2:C30 in the name box and press delete

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Workshops" wrote in message
...
I have a sheet that requires me to clear all the cells to continue. My cell
are A2 to C30. Is there a button or something I can have to clear them all
at
once?