Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |