Almost everyone knows how to use Google sheets, there is nothing complicated about it. One of the many features in Google sheets is the “checkbox”. Google sheets provide you with the checkboxes that you can use for different tasks, answer questions or select product attributes, and much more.
Checkboxes are a creative way to make your sheets look more attractive. You can also use data validation to assign custom values to your checkbox in Google sheets. There are many ways in which you can insert a checkbox in Google sheets. If you are wondering how to insert a checkbox in Google sheets then you have landed in the right place.
In this article, we shall provide you with how to insert checkbox in google sheets. We hope this article caters to everything you have been looking for. Keep reading the post if you are keen on knowing!
How To Insert A Checkbox In Google Sheets?
As mentioned above, there are many different ways in which you can insert a checkbox in Google sheets. Here are the list of ways in which you can easily insert a checkbox:
Way 1: Insert A Checkbox In Google Sheets By Using The Format Option:
To insert a checkbox in google sheets by using the format option, first open Google docs > Format > Bullets and Numbering > Bullet List > Bullet > Save The Document
You can insert a checkbox in Google sheets easily by using the format option. Follow the given steps below:
Step 1: Click on Google docs and click on the “Blank (+)” option to create a new document.

Step 2: When you wish to write, click on the “Format” option at the top of the menu.

Step 3: Click on “Bullets and Numbering”

Step 4: Now simply click on the “Bullet list” option.

Step 5: On the upper right side you will find the checkbox option. Click on the clear box bullet.

Step 6: Now you should type the list of items one by one. You can click on enter or return key and it will automatically generate another checkbox.

Step 7: Now simply save the document.
Now if you feel like creating a checkbox into a check, you can follow the steps mentioned below:
Step 1: By clicking you can highlight the checkbox. Highlighting more than one checkbox will edit all highlighted one.

Step 2: If you are using Mac, you can use ctrl + click or simply right click on the mouse.
Step 3: The pop menu will appear and then click on the checkmark.

Step 4: The particular item will now be checked.

Step 5: Now if you wish to remove a check, you can click on Ctrl + Z and it will immediately undo it. If you have made the check earlier then you remove it by:
1: Highlighting the check mark
2: On the top menu you will find the Format option, click on that
3: Hovering over Bullet list
4: Clicking on the checkbox option
5: As with the checkmark, highlighting more than one item will edit all highlighted items
Way 2: Insert A Checkbox In Google Sheets By Using The Insert Option:
To insert a checkbox in Google sheets by using the insert option open Google Docs > select multiple cells > Insert > Checkbox >
You can insert a checkbox in Google sheets by using the insert option, you can do that by following the steps mentioned below:
Step 1: Click on Google docs and click on the “Blank (+)” option to create a new document.

Step 2: You should highlight the cells that you want to add. You can also select multiple cells by clicking on the mouse or by holding down the ctrl key and then clicking on individual cells.

Step 3: Click on “Insert” present on the top menu

Step 4: A drop down menu will appear and then click on checkbox

Step 5: The highlighted should now have checkboxes, clicking on the checkboxes will toggle the checkmark on or off.

Google sheets also allows you ways to customize the checkbox and can be toggled on and off. Follow the steps mentioned below to do that:
1: Highlight the cells that already contain checkboxes

2: Click on “Data” that is present on the top menu

3: A dropdown menu will appear, click on “Data validation”

4: In the pop-up screen try to make sure that criteria is set to the checkbox. If required, click on the arrow next to it shown in the dropdown menu.

5: Now, click on the “use custom cell values”

6: You can type the value you wish to see

7: Google sheets will treat invalid input by giving a warning or directly rejecting the input

8: When you are done, just click on save and you will be done.

Way 3: Insert A Checkbox In Google Sheets On Android:
There are two ways in which you can access Google sheets on Android, one is by using the Google play store and the other is by using the web browser. If you are using the web browser then you can simply do that by following the above steps mentioned. On the other hand if you are using your phone device then there is no direct way of inserting the checkbox. It is because the functions of phone devices are limited. You can change that by getting Add-ons to increase its functioning but presently it is not supportive.
For now, it is better to stick to a web browser or use a desktop.
Also Read: How To Set Print Area In Google Sheets? Step-By-Step Guide!
Way 4: Insert A Checkbox In Google Sheets On iPhone:
There is no difference between the iOS version or the Android version. The steps to follow for the checkbox are the same as the Android one. Similarly as with Android, you cannot use it on an IPhone. It is better to go with the web browser or use a desktop.
Way 5: Insert A Checkbox In Google Sheets Using An Android Device:
To insert a checkbox in Google sheets using an Android device open the Google sheet app > click on (+) > New spreadsheet > select the boxes > Data validation > Tap > Save
Different from Google docs, the mobile version of Google sheets for Android has its function intact. If you want to create a checklist then follow the steps mentioned below:
Step 1: Open the Google sheet app

Step 2: On the lower right side you will find the ( + ) option, click on it.

Step 3: Now click on the New spreadsheet button

Step 4: Then simply select the checkboxes you want to add

Step 5: On the upper right side of your screen you will find the three dots icons

Step 6: A pop menu will appear and then click on “Data Validation”

Step 7: Click the drop down menu that is present under criteria

Step 8: Click on “Tap” box

Step 9: On the upper right side you will see the “Save” button, click on it

Step 10: The cells should now have checkbox that can be toggled on and off

Similarly you can access Google sheets through a mobile web browser by following the same steps mentioned above.
Way 6: Insert A Checkbox In Google Sheets On An IPad or iPhone:
There is no major difference between creating a checkbox in Google Sheets using an iPhone or Android device, you can follow the same steps mentioned above.
Also Read: How To Make A Double Line Graph In Google Sheets And Google Docs?
Wrapping Up:
Adding a checkbox in Google sheets is easy but in any case, if you have any trouble then you can find all the solutions to your problems in this article. In this article, you will find all the ways in which you can insert a checkbox in Google sheets. You can do that in different ways according to your preference.
Frequently Asked Questions
1. How Do I Insert A Checkmark On Google Sheets?
If you want to insert a checkmark on Google sheets then first select the cells > Insert > Checkbox in Google sheets menu > Click any box once and the tick symbol will appear.
2. Is There A Check Symbol In Google Sheets?
To get the check symbol in Google sheet you need to first go to the cell > enter CHAR formula. As soon as you do that and hit enter it will show you the check mark symbol.
3. How Do I Add Multiple Checkboxes In Google Sheets Or Excel?
You can add multiple checkboxes by selecting B2 cell and then clicking on the bottom right corner of the cell and dragging it down to B13. You will get 11 more checkboxes with the same text.
4. How To Insert Checkbox Using Format Option?
To insert a checkbox in google sheets by using the format option, first open Google Docs > Format > Bullets and Numbering > Bullet List > Bullet > Save The Document