Numbers checkmark multiple checkboxes

I would select a cell with a checkbox in the new state you want, then select the cells you want to update by selecting one cell then hold the command key while clicking the others (to add them to your selection), then paste

Select cell with checked box, copy

Now select the destination cells using <command> + click:

Paste:

OK. Post back when you know that solution. I would be interested in knowing it too.

One simple way that works here is:

1. Select the cells with the checkmarks you want to activate.
   
2. With the cells selected, hit the 1 key.
   
   

To turn off checkmarks select the cells and hit 0 key.

SG

Hi Bruce,

So how does this workflow (using SG's example):

1. Click cell B2 to select it.
2. Click cell B4 to select it.
3. Click cell B6 to select it.
4. Press 1 to set the selected cells to TRUE (checked).

improve on this workflow:

1. Click the checkbox in B2 to check it.
2. Click the checkbox in B4 to check it.
3. Click the checkbox in B6 to check it.

Just curious.

Regards,

Barry

Thanks for sharing this!

"I've been using the 0 and 1 keys now and they work great."

And doing the cells one at a time, using return or the down arrow to move to the next cell to be checked?

More actions, but staying on the keyboard as opposed to reaching for the mouse, so probably more efficient in that regard.

Regards,

Barry

Thanks for the green check, and for the interesting question! I'm not quite sure exactly how I stumbled on this (apparently) undocumented feature, but I selected non-contiguous cells (by holding down the command key and clicking individual cells) and then experimented with different keys, trying 1 first because I knew it sometimes stands for TRUE and that a checked Checkbox is also TRUE. To my surprise hitting the 1 did the trick! Then I thought, 0 sometimes stands for FALSE, and sure enough... Anyway, it's nice to have this handy way to toggle multiple Checkboxes on and off.

SG