1. Open the Google Sheets spreadsheet in your browser (or create a new one).
To open a Google Sheet, simply go to your web browser, type in sheets.google.com, and log in with your Gmail account. If you wish to create a new spreadsheet, click on the red “+” button at the top right and choose the “Blank Spreadsheet” option.
2. Prepare the spreadsheet with data to allow you to create a list (for example, add a list of products to check off in a column).
To prepare your Google Sheet for creating checkboxes, first, enter any necessary data into rows and columns on the spreadsheet. For example, if you wanted to create a checklist for groceries, you would need to have all items listed in one column with their corresponding details such as quantity or pricing in other columns.
3. Select the column and rows to the right of the list where you want the checkboxes to appear.
Once your data is entered, select those column(s) and rows where you want to place your checkboxes. To select multiple columns, click and drag your mouse across them.
4. After selecting the column and rows, click Insert from the toolbar at the top.
In order to add checkboxes in Google Sheets, you’ll need to use its “Insert” option located in the toolbar at the top of the page. Click on it and a drop-down menu will appear with various options for inserting data into your spreadsheet.
5. From there, select Checkbox from the menu.
This will bring up another drop-down box which contains several options for adding a checkbox to your spreadsheet, such as “Checkbox (checked)” or “Checkbox (unchecked)”. Select the option that best fits your needs and click on it.
6. That’s it. Your checkboxes will appear in the Google Sheet where you specified.
Your checkboxes should now be visible in the cells where you had selected them. To mark or unmark the boxes, simply press them individually or select them and type TRUE or FALSE into the formula bar above - TRUE meaning checked and FALSE meaning unchecked.
7. The checkboxes will appear—press the checkboxes individually to mark or unmark the values.
You can mark or unmark the checkboxes by simply pressing them individually. This will allow you to quickly build lists for tasks, products, and other items that need to be completed.
8. Alternatively, select the checkbox, then type TRUE or FALSE in the formula bar, where TRUE means the checkbox is checked, while FALSE means it’s unchecked.
Alternatively, you can also select a particular checkbox and type either TRUE or FALSE into the formula bar above it. Typing TRUE will result in the box being marked while typing FALSE will result in it being unmarked.
9. If you want to allow other users to mark checkboxes, make sure to update the sharing settings to allow full edit access to the spreadsheet.
If you are collaborating with other users on the Google Sheet and wish for them to mark checkboxes as well, make sure to update the sharing settings in order to give everyone full edit access to the document so they can make changes where necessary. This will ensure all collaborators have the ability to mark and unmark checkboxes.