| 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 | |||
Hybrid Mode
