reset cells to 0 all at once

W

Workshops

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?
 
P

Peo Sjoblom

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
VBA Coding Help for Beginner 0
Re-title multiple MS Project .mpp files at once 0
Crating User Form to Add Names 1
Request Form - Alert Team Member 0
Word macro that can call cells out of Excel for a find and replace 0
Section and Page numbering 0
Cannot open any folders (pinned or recent) from Word 365 Open Dialogue/Backstage 0

Top