How to Insert A Checkbox In Google Sheets

How to Insert A Checkbox In Google Sheets

Who would have thought that a checklist symbol could be so important and useful when working on Google Sheets? Whether you are making a to-do list or keeping a check on what all things you need to do, you need a checklist. Unlike Microsoft Excel, it is not that easy to add a checkbox in Google Slides. However, it can be done.

In this post, we have listed a step by step guide to insert a checkbox in Google Sheets.

Steps to Insert a Checkbox in Google Sheets

It has always been possible to add a checkbox in Google Sheets. Earlier, you needed to use CHAR function and a number related to the special character which is similar to a checkbox. However, now it can be done with rather an easier process. It can be inserted from the toolbar now.

Step 1: Login to your Gmail account and click on the grid to get Google Drive.

Step 2: Go to Google Drive and locate and open the spreadsheet on Google Sheets.

Step 3:  Now select the cells where you want checkmarks. It is better to create a list first and add checkmark by selecting the next empty column beside your list later.

how to insert checkbox in excel
Image Source:

Step 4:  Locate Insert from the menu bar and click on it. From the context menu, choose Tick Box.

Step 5: In case you have inserted checkmark in the wrong cell, you can remove it by selecting and pressing Delete.

Note: You can customize the size of the checkboxes. To do that, you need to change the font size from the toolbar at the top of the window.

See Also: An Easy Way To Add Prefix To All Cells In Excel

Old Method of Adding Checkmark in Google Sheet:

Though the earlier method is a bit tricky but it can be used if the first method doesn’t work for you. Follow these steps to insert a checkbox in Google Sheets:

Step 1: Write down your to-do list and select the column cells beside it.

Step 2: Right-click on the selected cells and from the drop-down menu, choose Data Validation.

data validation to insert check box in google sheet

Step 3: You will get Data Validation window. Select “List of items” beside Criteria option.

insert data validation for check list google sheet

Step 4: Now copy ,  from the Google Doc ( Go to Insert-> Special Character-> type check mark to get and multiply to get ) Separate both the characters with a comma.

Step 5: Click Save and you will get a drop-down menu in the selected cell area.

In this way, you can select  for the work done and  for the pending or incomplete task. A check mark in Sheets can do wonders as it acts as a simple tool to maintain the list of daily errands. Moreover, it can also be used as data collecting tool to manage and organize your data on Google Sheets.

See Also: How To Hide Columns And Rows in Excel

Srishti Sisodia

Srishti Sisodia is a technical content journalist at Systweak Software. Apart from being a capable engineer, her affinity for inscription draws her towards writing interesting content about contemporary technologies and progressions. She is an avid reader and a fare connoisseur. She relishes different cuisines and when it comes to baking, she takes the cake!

Sign Up for Our Newsletters

Enter your email address in the below field to subscribe to our Newsletter

0 Comments on “How to Insert A Checkbox In Google Sheets”

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.