Then, double-click on the cell or press F2 so it’s in edit mode. The first step to take when you want to use the emoji checkmark in your spreadsheet is to make sure you select where you want to insert the checkmark.
The process requires a keyboard shortcut to access the emoji keyboard on your Windows device. You can use checkmarks with the emoji keyboard in your spreadsheet. Insert a Checkmark with the Emoji Keyboard Once you have this in your sheet, you can convert the formula to a value in several ways. = UNICODE ( "☑" )įor example, the above formula will give a result of 9745. It takes a text character and returns the corresponding unicodeNumber of the character. UNICODE is another simple function with one argument. Quick Tip: If you don’t know the unicodeNumber of a character, you can use the UNICODE function to return the unicodeNumber. It will show you a preview of formula results, so you can see the character your number represents before you hit Enter.Īs the unicodeNumber changes, the character in the preview also changes. Take note of the preview at the top of the syntax. You can use them in the UNICHAR function as illustrated below = UNICHAR ( 9745 )įor example, the above formula will produce the ☑ character.
The UNICHAR function is a text function that will help you return any character based on this unique code of the character.Ĭheckmarks in Google Sheets have the following unicode numbers. The unicodeNumber refers to the unique number that represents the character you want the UNICHAR function to return.Įvery character supported in the spreadsheet is coded using unique numbers/codes. It’s a simple function because it takes just one argument. This method requires that you use one of the inbuilt functions called UNICHAR. Insert a Checkmark with the UNICHAR Function You can find a variety of checkmarks with a Google search and try to copy and paste those results as well. All you need to do is copy any of these checkmark characters and paste them into your spreadsheet. This first method is simple and easy to use. Insert a Checkmark with Copy and Paste ✓✔☑✅ Get your copy of the example workbook and follow along. This post will explore all the different ways you can insert checkmarks into your Google Sheets. The checkmark or tickmark symbol ✔ is one of the many characters that can help make your spreadsheet a dynamic and visually interesting tool. These can help to add great visual indicators for at-a-glance information. There’d be tasks that need assigning to different people and you will also want to keep track of the progress of each task. Imagine you have a project to accomplish within a specific timeline. Spreadsheets are a very dynamic tool that can be used in many different situations. Spreadsheets have a varied range of applications because they support the use of various characters, symbols, images, and graphics. When you use spreadsheets, you often only think of numbers and data analysis.īut the spreadsheet isn’t all just about numbers. This post will show you all the different ways you can insert checkmarks or tickmarks into your Google Sheets.