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

What Do You Think?
  • Upvote
  • Funny
  • Love
  • Surprised
  • Angry
  • Sad

Leave a Reply