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" <[email protected]> wrote in message
news:[email protected]...
>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?