Check Mark in Google Sheets

Check Mark in Google Sheets

Google Sheets is one of the best applications available online for organizing, arranging, and optimizing information. Using this application, the data can be systematically arranged in rows and columns, calculations can be carried out, charts can be included, etc. One of the major advantages of using a Google Sheet is that it has numerous customization options which can be effectively used to add to the appeal of the sheet. Various fonts, color palettes, styles, etc. are present in them and one such chief tool in a Google Sheet is the Checkmark in it.

A check mark stands for a symbol that can be put into any particular cell of a Google Sheet. A checkmark symbol can be anything and everything from a simple tick mark or cross mark to alphabets or numbers. They are assumed of a particular value when present inside a sheet and otherwise, they usually stand for nothing. Among the numerous options, a tick mark is popularly used as a checkmark in most documents.

Even after providing a checkmark in a particular cell, the user can type in numbers or letters before or after the checkmark. 

How to put a checkmark in Google Sheets?

Method 1

Step 1. Open the Google Sheets application on the device.

Step 2. Click on the Format option at the top menu bar.

Step 3. Click on the Number option from the drop-down menu that appears.

Step 4. From the options that appear, click on the Custom Number Format.

Step 5. On the window that appears, there are numerous options to choose from and the user can pick any one of them as the checkmark for the sheet and click on Apply option that is present at the bottom of the window.

Method 2

CHAR Function is an advanced feature present in the Google Sheets which can be effectively used to put checkmarks in the Google Sheets. Unicodes are numbers that can be used to represent various numbers within Google Sheets. Each Unicode stands for each of the numbers. This feature can be combined with the CHAR function equipped with Google Sheets to add numerous symbols to a sheet.

Step 1. Open the Google Sheets and choose the required sheet to work with.

Step 2. Four different types of checkmarks can be generated by several different CHAR formulas. Decide on which one to choose for the sheet.

  • – This checkmark can be created by entering =CHAR(10003) into any cell.

– This can be created by entering =CHAR(10004) 

– This symbol can be generated by =CHAR(128504) 

– This symbol can be created by =CHAR(9745)

– This symbol can be generated by =CHAR(128505)

Step 3. Type the required CHAR formula into the concerned cell and click enter.

Method 3

One of the easiest ways to put a checkmark in Google Sheets is to copy it from any other sheets. The user can open any other sheet which contains the required checkmark and copy-paste it to the sheet being worked on presently. 

Step 1. Open the Google Sheets application, and open a sheet that contains a sample checkmark.

Step 2. Right-click on the required checkmark and click on the Copy option.

Step 3. Open the sheet into which the checkmark has to be provided. Find the cell to be filled, right-click on the cell and click on the Paste option from the drop-down menu.

The check mark will be present in the chosen cell now. 

Method 4

Google Docs contain an easy option to access special characters which include checkmarks. The user can create a checkmark on Google Docs and can simply copy it to Google Sheets.

Step 1. Open Google Docs on the device and open a blank document.

Step 2. Click on the Insert option in the top menu bar.

Step 3. From the drop-down menu, click on the Special Characters option.

Step 4. A window with a countless number of special characters appears on the screen.

Step 5. The user can either search for the name of the symbol or else draw the symbol on the slot provided.

Step 6. Once the symbol is found, click on it and it can be noticed that the chosen symbol is appearing immediately on the document.

Step 7. Close the Special characters window, copy the symbol and paste it onto the required cell in the Google Sheets.