How To Insert A Checkbox In Google Sheets: Follow The Steps!

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!

Create to do list with Google Sheet...
Create to do list with Google Sheets Checkbox

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.

How To Insert A Checkbox In Google Sheets

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

How To Insert A Checkbox In Google Sheets

Step 3: Click on “Bullets and Numbering”

How To Insert A Checkbox In Google Sheets

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

How To Insert A Checkbox In Google Sheets

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

How To Insert A Checkbox In Google Sheets

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.

How To Insert A Checkbox In Google Sheets

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.

How To Insert A Checkbox In Google Sheets

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.

How To Insert A Checkbox In Google Sheets

Step 4: The particular item will now be checked. 

How To Insert A Checkbox In Google Sheets

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.

How To Insert A Checkbox In Google Sheets

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.

How To Insert A Checkbox In Google Sheets

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

How To Insert A Checkbox In Google Sheets

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

How To Insert A Checkbox In Google Sheets

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

How To Insert A Checkbox In Google Sheets

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

How To Insert A Checkbox In Google Sheets

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

How To Insert A Checkbox In Google Sheets

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

How To Insert A Checkbox In Google Sheets

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.

How To Insert A Checkbox In Google Sheets

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

How To Insert A Checkbox In Google Sheets

6: You can type the value you wish to see

How To Insert A Checkbox In Google Sheets

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

How To Insert A Checkbox In Google Sheets

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

How To Insert A Checkbox In Google Sheets

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

How To Insert A Checkbox In Google Sheets

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

How To Insert A Checkbox In Google Sheets

Step 3: Now click on the New spreadsheet button

How To Insert A Checkbox In Google Sheets

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

How To Insert A Checkbox In Google Sheets

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

How To Insert A Checkbox In Google Sheets

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

How To Insert A Checkbox In Google Sheets

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

How To Insert A Checkbox In Google Sheets

Step 8: Click on “Tap” box

How To Insert A Checkbox In Google Sheets

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

How To Insert A Checkbox In Google Sheets

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

How To Insert A Checkbox In Google Sheets

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

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top