Google sheets has a lot of cool features, one of those features is the ability to add checkable checkboxes. I’m not going to get into why you might want to insert checkboxes in Google sheets today.
But if you do want to insert checkboxes in Google sheets, you’re in the right place because that’s exactly what I’m going to show you how to do.
Prefer to watch a video about how to add checkboxes in Google Sheets? Click here.
How To Insert Checkboxes In Google Sheets
To insert a checkbox in Google sheets, you’ll first need to select the cell you want to insert the checkbox into.
If you just want to insert a single checkbox in a single cell, you can just click on the one cell. Or, if you want to insert multiple checkboxes going down one column to create a checklist or something like that, you can click on the top cell and drag down to select all the cells you want to insert a checkbox into.
Now, to insert a checkbox in all of the selected cells, just click “Insert” in the menu across the top of the screen…
And then, in the menu that appears, click “Checkbox”.
Now, a checkbox will be inserted into each of the selected cells!
Now that the checkboxes are inserted, you might want to make the column they’re in a bit smaller as the checkboxes aren’t very big. Obviously, you won’t be able to do this if you have other text in different cells in the same column, but if this column only has checkboxes in it, it might be a good idea.
To do this, just double click on the line to the right of the column that the checkboxes are in at the top of the spreadsheet. So if the checkboxes were in column A, you would need to double click on the line between A and B.
Then, the column will be automatically shrunk down so that it’s exactly the right size for the checkboxes.
Now, you might want to type some information next to each checkbox so you know what the checkbox means:
But once you’re done with that, that’s really all there is to do.
How To Check The Checkboxes
Now that you’ve inserted the checkboxes, all that’s left to do is check them. And this is the easy part, to check a check box, all you have to do is click on the one you want to check, and a check mark will appear in the box!
And then, if you want to uncheck a box, all you need to do is click on it again to uncheck it.
You can also type in the text field if you prefer. If you click on the cell the checkbox is in, and type FALSE in all caps in the text field, the box will be unchecked.
Or, if you type TRUE in the text field in all caps, the box will be checked.
Obviously, this is more effort than just clicking on the box to check and uncheck it, but if you ever wanted to set up some sort of complex equation involving the checkboxes, this might be helpful.
And, that’s all there is to it! Now you know everything there is to know about inserting checkboxes in Google Sheets!