| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check boxes
I have added check boxes to my spreadsheets and I would like to be able to
tick or clear them all in one go. Is this possible rather than ticking them individually one by one? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check boxes
Try this:
Edit--GoTo--Special--Objects and see if you can check or uncheck them all at once. "MACAVITY500" wrote: I have added check boxes to my spreadsheets and I would like to be able to tick or clear them all in one go. Is this possible rather than ticking them individually one by one? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check boxes
My edit menu has "object" greyed out so this option seems unavailable. Any
other ideas? "Dave F" wrote: Try this: Edit--GoTo--Special--Objects and see if you can check or uncheck them all at once. "MACAVITY500" wrote: I have added check boxes to my spreadsheets and I would like to be able to tick or clear them all in one go. Is this possible rather than ticking them individually one by one? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check boxes
Go back to the edit menu and follow this menu path:
Edit--Go To--Special--Objects Ignore the 'objects' you see when you first open the Edit menu. That's not what I'm talking about. "MACAVITY500" wrote: My edit menu has "object" greyed out so this option seems unavailable. Any other ideas? "Dave F" wrote: Try this: Edit--GoTo--Special--Objects and see if you can check or uncheck them all at once. "MACAVITY500" wrote: I have added check boxes to my spreadsheets and I would like to be able to tick or clear them all in one go. Is this possible rather than ticking them individually one by one? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check boxes
It's saying "No objects found"
"Dave F" wrote: Go back to the edit menu and follow this menu path: Edit--Go To--Special--Objects Ignore the 'objects' you see when you first open the Edit menu. That's not what I'm talking about. "MACAVITY500" wrote: My edit menu has "object" greyed out so this option seems unavailable. Any other ideas? "Dave F" wrote: Try this: Edit--GoTo--Special--Objects and see if you can check or uncheck them all at once. "MACAVITY500" wrote: I have added check boxes to my spreadsheets and I would like to be able to tick or clear them all in one go. Is this possible rather than ticking them individually one by one? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check boxes
It's saying "No Objects Found" any more advice?
"Dave F" wrote: Go back to the edit menu and follow this menu path: Edit--Go To--Special--Objects Ignore the 'objects' you see when you first open the Edit menu. That's not what I'm talking about. "MACAVITY500" wrote: My edit menu has "object" greyed out so this option seems unavailable. Any other ideas? "Dave F" wrote: Try this: Edit--GoTo--Special--Objects and see if you can check or uncheck them all at once. "MACAVITY500" wrote: I have added check boxes to my spreadsheets and I would like to be able to tick or clear them all in one go. Is this possible rather than ticking them individually one by one? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can one cell hold multiple check boxes (and then sort based off e. | Excel Discussion (Misc queries) | |||
| Check Boxes | Excel Worksheet Functions | |||
| why do check boxes move when printing excel spreadhseets | Excel Discussion (Misc queries) | |||
| Check boxes in a column | Excel Discussion (Misc queries) | |||
| Adding Check Boxes | Excel Discussion (Misc queries) | |||
Linear Mode
