tick check boxes in a column at once

PharaK SupportServiceManager

This is embarrassing because I used this method a lot just 3 months ago after finding the tip right here in the community. I remember the method anymore. Been trying and searching for 2 hours. I want to tick all checkboxes in a column at once. Please help.

Andrew Stewart

Tick the first checkbox. Cntl-C to copy, Cntl-Shift-Down Arrow to extend selection to the last row in the sheet, Cntl-V to paste the value to all cells in the column.

Andrée Starå

On a mac, you can either select a cell(the cells) that you want to change the checkbox by:

1. Holding Shift down and using the Arrow keys to select the range
2. Holding CMD and clicking with your mouse to select the cells

To check/uncheck the selected boxes you can either:

1. Press the Spacebar
2. Click with the mouse in one of the cells you've selected

Pro-tip. This also work for Stars, Flags and more.

Make sense?

Andrew Stewart

Tick the first checkbox. Cntl-C to copy, Cntl-Shift-Down Arrow to extend selection to the last row in the sheet, Cntl-V to paste the value to all cells in the column.

Andrée Starå

Hi,

Another option would be to select the cells that you want to check the box off and check one, and the rest will also get checked.

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Please help the Community by marking the post that helped answer your question or solve your problem with the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

On a mac, you can either select a cell(the cells) that you want to change the checkbox by:

1. Holding Shift down and using the Arrow keys to select the range
2. Holding CMD and clicking with your mouse to select the cells

To check/uncheck the selected boxes you can either:

1. Press the Spacebar
2. Click with the mouse in one of the cells you've selected

Pro-tip. This also work for Stars, Flags and more.

Make sense?

Andrée Starå

Excellent!

Happy to help!