How to Make a Checkmark in Google Sheets

Greetings, my fellow spreadsheet enthusiasts! If you're reading this, you're probably wondering how to add a checkmark to your Google Sheets document. Fear not! As a self-proclaimed Google Sheets wizard, I'm here to guide you through the process step-by-step.

The Checkmark Symbol

Before we begin, let's talk about the checkmark symbol. The checkmark symbol, also known as the tick mark, is a symbol that indicates the completion of a task, or the correctness of an item on a checklist. It's a simple yet powerful symbol that can elevate your spreadsheet game. Luckily, it's super easy to add to your Google Sheets document.

Option 1: Copy and Paste

If you're looking for the quickest and easiest method of adding a checkmark to your document, then look no further. All you have to do is copy and paste the checkmark symbol! Here's how:

  1. Navigate to a web page with a checkmark symbol or copy it from this article: ✓
  2. Highlight the symbol by clicking and dragging over it.
  3. Right-click on the highlighted symbol.
  4. Select "Copy" or use the keyboard shortcut "Ctrl + C" (Windows) or "Command + C" (Mac) to copy the symbol.
  5. Navigate to your Google Sheets document.
  6. Select the cell where you want to add the checkmark symbol.
  7. Right-click on the cell and select "Paste" or use the keyboard shortcut "Ctrl + V" (Windows) or "Command + V" (Mac) to paste the checkmark symbol.

And just like that, you now have a checkmark in your Google Sheets document! It truly doesn't get easier than that.

Option 2: Use the CHAR Function

If you're looking for a more programmatic approach to adding a checkmark to your document, then we can use the CHAR function. The CHAR function in Google Sheets returns a character specified by a number. Here's how:

  1. Select the cell where you want to add the checkmark symbol.
  2. Type the following formula into the cell: =CHAR(10003)
  3. Press "Enter" on your keyboard.

And just like that, you now have a programmatic checkmark in your Google Sheets document! The CHAR function can be a powerful tool for adding symbols and characters to your document.

Wrap Up

Congratulations, you've made it to the end of the article! I hope you found this tutorial helpful in adding a checkmark to your Google Sheets document. Remember, adding the checkmark symbol is a simple yet effective way to indicate the completion of a task or the correctness of an item on a checklist. Whether you choose to copy and paste or use the CHAR function, you now have the knowledge to elevate your spreadsheet game.

Until next time, fellow spreadsheet wizards!

close
By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.