alberg15

Q: How to cear all checks from a checklist

Hi. I have a long checklist in a pricing sheet where I can select items for inclusion in a bid. Is there a way to "clear all" checkmarks at once, rather than unchecking them one by one? I don't want to delete the check boxes, just to uncheck them. Thanks -ab

Posted on Jun 26, 2012 8:42 AM

Close

Q: How to cear all checks from a checklist

  • All replies
  • Helpful answers

Page 1 Next
  • by Jerrold Green1,

    Jerrold Green1 Jerrold Green1 Jun 26, 2012 9:15 AM in response to alberg15
    Level 7 (29,996 points)
    Jun 26, 2012 9:15 AM in response to alberg15

    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

  • by alberg15,

    alberg15 alberg15 Jun 27, 2012 6:08 AM in response to Jerrold Green1
    Level 1 (0 points)
    Jun 27, 2012 6:08 AM in response to Jerrold Green1

    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

  • by Wayne Contello,

    Wayne Contello Wayne Contello Jun 27, 2012 6:41 AM in response to alberg15
    Level 6 (19,007 points)
    iWork
    Jun 27, 2012 6:41 AM in response to alberg15

    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.

  • by Jerrold Green1,

    Jerrold Green1 Jerrold Green1 Jun 27, 2012 7:09 AM in response to alberg15
    Level 7 (29,996 points)
    Jun 27, 2012 7:09 AM in response to alberg15

    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

  • by Wayne Contello,

    Wayne Contello Wayne Contello Jun 27, 2012 7:13 AM in response to Wayne Contello
    Level 6 (19,007 points)
    iWork
    Jun 27, 2012 7:13 AM in response to Wayne Contello

    Screen Shot 2012-06-27 at 9.12.49 AM.png

     

     

    select the first cell of the table to the right (a table filled with unchecked check boxes)

    select all using the <CMD>+a

    copy <CMD>+c

    select destination cell in table to left, then paste, <CMD>+v

  • by Barry,

    Barry Barry Jun 27, 2012 9:48 AM in response to alberg15
    Level 7 (32,271 points)
    Jun 27, 2012 9:48 AM in response to alberg15

    Here's another variation, using the Inspector:

     

    1. Select the checkbox cells.
    2. In the Cell Format Inspector, change the format to Text
    3. Press delete to clear the TRUE or FALSE value from all of the selected cells.
    4. 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

  • by Badunit,

    Badunit Badunit Jun 27, 2012 3:10 PM in response to Barry
    Level 6 (11,705 points)
    iTunes
    Jun 27, 2012 3:10 PM in response to Barry

    It is easier than all these suggestions.

     

    1. Select all the checkboxes you want to check or uncheck.
    2. In the cell inspector, click on either "Checked" or "Unchecked"
  • by Jerrold Green1,Helpful

    Jerrold Green1 Jerrold Green1 Jun 27, 2012 3:44 PM in response to Badunit
    Level 7 (29,996 points)
    Jun 27, 2012 3:44 PM in response to Badunit

    Badunit,

     

    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

  • by Badunit,

    Badunit Badunit Jun 27, 2012 4:21 PM in response to Jerrold Green1
    Level 6 (11,705 points)
    iTunes
    Jun 27, 2012 4:21 PM in response to Jerrold Green1


    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.

  • by alberg15,

    alberg15 alberg15 Jun 27, 2012 4:51 PM in response to Badunit
    Level 1 (0 points)
    Jun 27, 2012 4:51 PM in response to Badunit

    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

  • by Badunit,

    Badunit Badunit Jun 27, 2012 5:21 PM in response to alberg15
    Level 6 (11,705 points)
    iTunes
    Jun 27, 2012 5:21 PM in response to alberg15

    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.

  • by Badunit,

    Badunit Badunit Jun 27, 2012 6:59 PM in response to Badunit
    Level 6 (11,705 points)
    iTunes
    Jun 27, 2012 6:59 PM in response to Badunit

    Best I can discover in the iPad version is to Copy/Paste or Fill to clear the checkboxes.

  • by jlinaschke,

    jlinaschke jlinaschke Aug 3, 2016 3:25 PM in response to Wayne Contello
    Level 1 (29 points)
    Video
    Aug 3, 2016 3:25 PM in response to Wayne Contello

    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!

  • by laurieload,

    laurieload laurieload Aug 31, 2016 3:19 AM in response to jlinaschke
    Level 1 (4 points)
    Aug 31, 2016 3:19 AM in response to jlinaschke

    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."

Page 1 Next