Here are the formulas for a few different styles of checkmarks that you can use: Symbol You can use the Unicode of the checkmark symbols to display a checkmark with the CHAR function.

You can also use the CHAR function to add a checkmark symbol to your sheet. You should now have a small checkmark in your cell Right-click and select paste or press CTRL + V on your keyboard to paste.Double click into the cell where you want the checkmark to appear.Copy the checkmark symbol from above that you want in your spreadsheet.Here are a few different styles of checkmarks that you can copy: Copy and Paste CheckmarkĪnother pretty simple way to create a checkmark into your sheet is to copy and paste one from another application or site.įor example, you can create a checkmark in Google Docs and then copy it into sheets. To learn more about the different ways you can use checkboxes, read our full tutorial on how to use checkboxes in Google Sheets. Click on it and then box will be ticked and display a checkmarkĪdding a checkbox is the quickest way to get a checkmark into your spreadsheet, however, there are a lot of other benefits of using checkboxes. From the drop-down menu select CheckboxĤ.

Click on the cell where you want to add the checkmarkģ. The benefit of this method is that you can check and uncheck the box which your sheet more dynamic because you have some interactive elements to your spreadsheet.ġ. If you’re using checkboxes to track tasks in your team, why not have a look at our best online collaboration tools buying guide for more software options? You can also figure out which major platform suits you best by reading our Microsoft 365 vs Google Workspace comparison.The easiest method to add a checkmark to your spreadsheet is to simply insert a checkbox. Using Developer controls is the easiest way to work with checkboxes in both Word and Excel, while in Google Docs, checkboxes are easy to set up but may require optional table editing if you don’t want strikethroughs in your list. You should now be able to insert checkboxes and use them effectively across Word, Excel, and Google Docs. You can now tick and untick the boxes without any text strikethroughs. Then, select 0 pt and the table borders should blend in the page background colour. To remove table borders, select the whole table and click the Border width icon, usually located under the three dots icon at the right end of the top ribbon. Step 3 (optional): Remove checklist table bordersįirst, you may want to place the checkboxes and list items closer together by dragging the column divider to the left with your cursor.

Copy or type your list into the second column, then select the cells in the first column and copy or insert a checklist, without text, according to the previous step.

How to add a check box in google sheets