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?
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?
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks