-
All replies
-
Helpful answers
-
Jun 26, 2012 9:15 AM in response to alberg15by Jerrold Green1,Al,
You can use Copy/Paste or Fill Down to quickly clear all the boxes. Uncheck the first box and make sure the cell is selected, Command-C. Shift-click the last box, Command-V.
Or, Uncheck the first box and make sure the cell is selected, Grab the Fill Handle (circle in lower right corner of cell) and drag it to the bottom.
Regards,
Jerry
-
Jun 27, 2012 6:08 AM in response to Jerrold Green1by alberg15,Thanks, Jerrold. That does work, but is stil more manual labor than I was trying to accomplish. I want to be able to have a one button "clear all checks" that will reset the nearly 100 checkboxes on the sheet. Any ideas on that are greatly appreciated. -ab
-
Jun 27, 2012 6:41 AM in response to alberg15by Wayne Contello,You could also select all the check boxes (when cleared), copy, then paste as a group to another table (for later use). When you want to clear all the check boxes, you can select all the cells in the "other" table, copy, then paste over the existing cehck boxes.
-
Jun 27, 2012 7:09 AM in response to alberg15by Jerrold Green1,alberg15 wrote:
Thanks, Jerrold. That does work, but is stil more manual labor than I was trying to accomplish. I want to be able to have a one button "clear all checks" that will reset the nearly 100 checkboxes on the sheet. Any ideas on that are greatly appreciated. -ab
There is no such feature in Numbers. The Checkbox format can only be set and cleared manually. Further, there is no way to program an equivalent function in the Spreadsheet World. It's the nature of spreadsheets, not a particular feature set in Numbers, that drives this behavior.
Your best bet is to redesign your document, if possible, to make it easy to use the procedure I outlined.
Jerry
-
-
Jun 27, 2012 9:48 AM in response to alberg15by Barry,Here's another variation, using the Inspector:
- Select the checkbox cells.
- In the Cell Format Inspector, change the format to Text
- Press delete to clear the TRUE or FALSE value from all of the selected cells.
- Change the format back to Checkbox (with the default setting "Unchecked")
Works best if all the checkboxes are in a single column, and all cells in that column are checkboxes.
Regards,
Barry
-
Jun 27, 2012 3:10 PM in response to Barryby Badunit,It is easier than all these suggestions.
- Select all the checkboxes you want to check or uncheck.
- In the cell inspector, click on either "Checked" or "Unchecked"
-
Jun 27, 2012 3:44 PM in response to Badunitby Jerrold Green1,★HelpfulBadunit,
You're right of course, if he has the Cells Inspector open and all the cells selected. My assumption was that he might be sitting there looking at a column of checkboxes and possibly was reluctant to open the Inspector.
When I'm in the midst of setting up a new document, I'd rather just copy a checkbox and paste it where I want a new one than go to the Inspector and fuss with that menu.
Jerry
-
Jun 27, 2012 4:21 PM in response to Jerrold Green1by Badunit,
Jerrold Green1 wrote:I'd rather just copy a checkbox and paste it where I want a new one than go to the Inspector and fuss with that menu.
Jerry
That's usually what I do too.
-
Jun 27, 2012 4:51 PM in response to Badunitby alberg15,This is close, guys. Very exciting. And it has me wondering if I could do a conditional statement that if a main cell is checked, then all others are checked. And this would allow me to "clear" the price estimate form of all checkmarks at once. I am tyring to do this wihout the Inspector because I plan to use the sheet on Numbers for the IPad, where there is no inspector.
I wish Numbers allowed you to name cells like in Excel. But if cell A:1 has a checkmark, then how would I write the equasion to put a checkmark in other cells? I hope that makes sense. Thanks, Alan
-
Jun 27, 2012 5:21 PM in response to alberg15by Badunit,Spreadsheets don't work that way. The contents of a cell are determined by the formula in the cell itself or by the data you type into it. A checkbox is a data entry cell and cannot be changed by the value of some other cell.
If this spreadsheet is to be used on an iPad, maybe you should ask your question in that forum and see what they have to say there.
-
Jun 27, 2012 6:59 PM in response to Badunitby Badunit,Best I can discover in the iPad version is to Copy/Paste or Fill to clear the checkboxes.
-
Aug 3, 2016 3:25 PM in response to Wayne Contelloby jlinaschke,I think this is a fantastic suggestion. In my case, the column isn't completely filled with checkboxes. Some are checks, some are empty. So copying the column while un-checked, pasting that into the last column in the spreadsheet, is brilliance. Now all I have to do is click on any cell in the last column, tap option-right-arrow to add a column (which copies all the checks, and the conditions formatting I have in there), then drag that over to the first column position, and finally delete the old, already-checked column.
Super suggestion, thanks!
-
Aug 31, 2016 3:19 AM in response to jlinaschkeby laurieload,Just discovered how to do this perfectly:
"Select or deselect multiple checkboxes: Select the cells, then press 1 to select all checkboxes or 0 to deselect all checkboxes."
