New: ready-to-use spreadsheet templatesExplore the collection →

Google Sheets tutorials›Errors›Checkboxes not working

Google Sheets · Verified tutorial

Checkboxes not working in Google Sheets

Insert working checkboxes in B2:B4. Leave every checkbox unchecked and do not change the task names.

Verified by JosephineJuly 25, 2026About 75 seconds

Quick answer

Insert working checkboxes in B2:B4. Leave every checkbox unchecked and do not change the task names.

Step-by-step

1

Select the targetInsert working checkboxes in B2:B4.

2

Apply the changeLeave every checkbox unchecked and.

Shortcut or faster method

Use the menu path shown in the video and keep the target range selected until the change is applied.

Expected result

B2:B4 contains unchecked Boolean checkboxes.

Common mistake

Changing the source values while applying the formatting or structure change.

Troubleshooting

Re-select B2:B4 and repeat the final action. B2:B4 contains unchecked Boolean checkboxes.

Example spreadsheet data

This is the clean fixture used for the verified run.

Task	Done
Send invoice
Review budget
Book meeting

Video transcript

Open the prepared Checkbox repair spreadsheet.
Select the target. Insert working checkboxes in B2:B4.
Apply the change. Leave every checkbox unchecked and.
B2:B4 contains unchecked Boolean checkboxes.