Easily Insert Checkboxes in Google Sheets

• Have you ever wanted to create a task list using Google Sheets?
• Now with Google sheets you can use checkboxes to do things like checklists or even more interesting things as you'll see in this video.
• Read on for instructions or watch the video to follow along.

Play Video

1. Go to Google Sheets

• Go to Google Sheets. If you're already logged in, you can access this by clicking on the Google apps icon on the top-right of the page, then clicking on "Sheets".

2. Create a new sheet

• Once you're on Google Sheets, you'll want to create a new sheet. Click on the plus icon to create a new spreadsheet.
• You can skip this step if you're modifying an existing sheet.

3. Select the cells to add checkboxes

• Select cells you'd want to add the checkboxes. You select by highlighting and dragging down or up a column.
• You can also select an entire column by clicking on the column's letter such as "B".

4. Go to 'Data Validation'

• After highlighting an area to add the checkboxes to, click on "Data" then click on "Data validation" option.
• This will led you the next screen (see next step).

5. Select Checkbox

• From the previous step, you will be presented with different options for setting up a data validation.
• So, under "Criteria", click and choose "Checkbox".

6. Data Validation Setup

• (1) From the previous step, you should now have "Checkbox" set as a criteria.
• (2) This option lets you choose whether or not to reject any other input that's not a checkbox.
• (3) You can also choose whether or not you want to display help text as well as modifying the text.
• Click "Save" button to finish setup.

7. Ready to use checkboxes

• Once the above setup is complete. You should now be able to check and uncheck the checkboxes.
• As you can see, you now have checkboxes ready for use.

That's it!

• You should now be able to quickly whoop-up todo lists, checklists etc with just Google sheets alone.
• You can even take this to another level by creating conditional logical statements.
• Let me know what you think by leaving your comment below and I'll be glad to read from you.

Related Pages

Create Google Workspace Aliases in Bulk with this Script

Creating Users & Groups in Google Workspace - the right way

Google Workspace OAuth Token Audit