Easily Insert Checkboxes in Google Sheets
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.

Related Posts
....
....