Data Validation to Insert Check Box, Tick Mark in Google Sheets If you want users to make tick marks, check boxes similar to Excel, the possibly best work around in Google Sheets is a drop down using the data validation feature. Then why data validation is required to insert check marks as well as check boxes in Google Sheets? You can apply all the above formulas in one sheet and afterward, you can directly copy the symbols from here and paste the required symbols in any cells, any sheets, and also in any Google Sheet files.

Now if you want just tick mark and check mark symbols, you can use the following formulas. To get check box, you can use the below formulas as per your requirement. How to Insert Check Box, Tick Mark in Google Sheetsįirst, let us see how to insert Check Box in Google Sheets. You can learn all these aspects and additionally learn here how to use check boxes as well as tick marks in Google Sheets calculations. Must Read: Restrict People from Entering Invalid Data on Google Doc Spreadsheet The Data Validation is only required if you want a user to make a choice. You can use Google Sheets CHAR function alone or in combination with Data Validation to insert Check Box, Check Box and Tick Mark Symbols in Google Sheets. I’ve detailed this at the end of this tutorial under the title Tick Box Using Data Validation Alone. It’s using data validation or through the Insert menu. Update: There is a new method now available in Google Sheets to insert check box that without using the Char function. Here is the best way to insert Check Box, Tick Mark in Google Sheets. You can follow this method too as there is no other option around at this time. Many Google Sheets users effectively use the CHAR function to insert Check Box, Tick Mark in Google Sheets.

How to insert checkbox in google docs