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".
![go to google sheet](https://cdn.prod.website-files.com/652583d059964c2e9f5a207f/652b59764611e9ca1ef1abf1_go-to-google-sheet-1030x579.png)
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.
![Create a new sheet](https://cdn.prod.website-files.com/652583d059964c2e9f5a207f/652b597629f6f7d9d292f0eb_create-a-new-sheet-1030x579.png)
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".
![select cells to add checkboxes - Google sheet checkboxes](https://cdn.prod.website-files.com/652583d059964c2e9f5a207f/652b5976fd19962a3385d113_select-cells-to-add-checkboxes-Google-sheet-checkboxes-1030x579.png)
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).
![Go to Data-validation - Google sheet checkboxes](https://cdn.prod.website-files.com/652583d059964c2e9f5a207f/652b5976675e9e3c342cd064_Go-to-Data-validation-Google-sheet-checkboxes-1030x579.png)
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".
![Checkbox data validation criteria](https://cdn.prod.website-files.com/652583d059964c2e9f5a207f/652b5976422fddacbf4b8ec3_Checkbox-data-validation-criteria-1030x579.png)
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.
![data validation setup - Google sheet checkboxes](https://cdn.prod.website-files.com/652583d059964c2e9f5a207f/652b5976cd21e846609a3ffa_data-validation-setup-Google-sheet-checkboxes-1030x579.png)
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.
![Checkboxes created - Google sheet checkboxes](https://cdn.prod.website-files.com/652583d059964c2e9f5a207f/652b59763b0b2fc334481de0_Checkboxes-created-Google-sheet-checkboxes-1030x579.png)
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.
![Type a comment Gmail label Manager](https://cdn.prod.website-files.com/652583d059964c2e9f5a207f/652b5976f9121f403ba97b25_Type-a-comment-Gmail-label-Manager-1030x579.png)
Related Posts
....
....