How to cear all checks from a checklist

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

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

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

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

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.

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

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

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.

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!

Thanks, Laurie.

Just to help others who read this thread, it works in Numbers 3.6.2

It doesn't work in Numbers '09, which was current when this thread was started.

Keep posting in Numbers for Mac 🙂.

Regards,

Ian.

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"

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.

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