There are several functions and formulas that allow you to insert check marks on your Sheets document. Luckily, we’ve compiled multiple ways of using these formulas in this article.
How to Put Check Mark in Google Sheets?
There is no definitive method to put a checkmark on your Google Sheet. However, you can access them directly within Google Sheets or through another external source. So, follow the steps mentioned below to apply these methods to use checkmarks on Google Sheets.
Through Insert Menu
Sheets has a checkbox option available as a part of the Insert feature. You can access this feature from the toolbar on Google Sheets. Follow the steps mentioned below to use a checkbox to add a Checkmark to your document.
Create a Drop Down Box
It is possible to add a checkmark on a cell by adding a dropdown box with check marks as options. You can follow the steps mentioned below to add two checkboxes to the dropdown box (with and without a checkmark).Google Sheets does not have a separate checkmark button to use on step seven mentioned above. So, you can copy the checkmark from step seven.
Copy From Google Docs
You can add a checkmark on your sheet by copying it from Google Docs. Follow the steps mentioned below to use Google Docs for checkmarks.
Through Data Validation
The data validation feature allows you to add dropdown menus on Sheets. However, adding a separate checkbox using the data validation feature is also possible. Follow the steps mentioned below to add a checkmark on a cell on your sheet.
Through Character Function
Commands and formulas are a common part of Google Sheets. However, there are special character codes that you can apply on a sheet to add checkmarks on a cell or range of cells. Follow the method mentioned below to use such character codes on your document.In step 3, =CHAR (128504) is the formula for a normal checkmark, =CHAR (10004) is for a bold check mark, and =CHAR (9745) inputs a checkbox with a checkmark. So, use the one you see fit.
