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.

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.