In the world of data management, visual cues are often far more effective than text. A simple checkmark (tick symbol) in Excel instantly communicates that a task is complete, a requirement is met, or a value is valid, creating a much more professional and intuitive interface than simply typing “Done” or “Completed.” While Excel is a powerhouse for calculation, its visual formatting tools are equally important for creating dashboards and trackers that are easy to read.
Mastering the art of inserting special symbols like checkmarks is a small skill that yields significant improvements in spreadsheet presentation. Whether you are building a to-do list, a project tracker, or an attendance sheet, there are several ways to achieve this. Below, we explore three distinct methods to insert checkmarks in Excel, ranging from keyboard shortcuts to menu options, helping you choose the workflow that best suits your needs.
Visual representation of a checklist in Excel with green checkmarks
Method 1: The “Pro” Way Using Wingdings 2 and Keyboard Shortcuts
This is arguably the most efficient method for frequent Excel users. By utilizing the Wingdings 2 font, you can turn regular keystrokes into symbols. This method is standard across the Microsoft Office suite, meaning the skills you learn here also apply to Word and PowerPoint.
To begin, select the cell or range of cells where you want the checkmarks to appear. Navigate to the Home tab on the ribbon and locate the Font dropdown menu. Scroll down or type to change the font to Wingdings 2.
User selecting the Wingdings 2 font from the Excel Home ribbon
Once the font is set, simply press SHIFT + P on your keyboard. Because you are using the Wingdings 2 map, the capital letter “P” will instantly render as a stylish checkmark. This is significantly faster than hunting through menus if you have a long list of items to mark as complete.
The result of pressing Shift + P in a cell formatted with Wingdings 2
Pro Tip for Data Status:
Often, you need to show both “Complete” and “Incomplete” statuses. In the Wingdings 2 font, if you press SHIFT + O (capital letter O), Excel will generate an “X” mark. This allows you to create a binary status system (Check vs. Cross) quickly without leaving the keyboard. This creates a clean, consistent look for task lists.
Animation showing the difference between Shift + P for check and Shift + O for cross
Method 2: The “Quick Fix” via Google Search
If you only need to insert a checkmark once or twice and do not want to mess with font formatting, the copy-paste method is universally effective. This is particularly useful if you are sharing the file and want to ensure the symbol remains a checkmark regardless of the fonts installed on the recipient’s computer (though standard Unicode characters are usually safe).
Simply open your web browser and search for keywords like “checkmark symbol” or “tick symbol copy.” Google provides these symbols directly in the search snippet.
Google search results displaying various checkmark symbols for copying
Highlight the symbol you prefer, press CTRL + C to copy it, then return to your Excel spreadsheet and press CTRL + V to paste it into the desired cell. Note that this method inserts the symbol as standard text, so you can keep your cell font as Arial, Calibri, or whatever theme font you are using.
Method 3: The Traditional Method Using the Symbol Menu
For those who prefer a visual interface or need a specific style of checkmark (such as one inside a box or a circle), the built-in Symbol menu is the best route. This method gives you access to the full library of characters available in your system.
First, click on the cell where you want the symbol. Navigate to the Insert tab on the main ribbon and look for the Symbols section on the far right. Click on the Symbol icon to open the character map dialog box.
The Insert tab in Excel highlighting the Symbol button location
In the dialog box that appears, you will see a “Font” dropdown. Select Wingdings 2 (or standard Wingdings) to view the available icons. You will see various styles of checks and crosses.
Click on the checkmark style that fits your design, then click the Insert button. You can continue to insert other symbols or close the box when finished. This method ensures accuracy as you can see exactly what the symbol looks like before adding it to your data.
The Symbol dialog box showing the selection of a checkmark in Wingdings 2
Conclusion
Excel offers flexibility to accommodate different user preferences, and inserting a checkmark is no exception. Whether you prefer the speed of the Shift + P shortcut with Wingdings 2, the simplicity of copying from the web, or the precision of the Insert Symbol menu, you now have the tools to make your spreadsheets more visual and professional.
We recommend the keyboard shortcut method for heavy data entry tasks due to its efficiency, while the Symbol menu is excellent for finding specific design variations. Try these methods in your next report and see how a simple visual element can improve data readability.
Did you find this tutorial helpful? Share your favorite Excel formatting tips with the “Thủ Thuật” community in the comments below!
References
- Microsoft Support: Insert a check mark or other symbol
- TechCommunity: Excel Keyboard Shortcuts and Special Characters
- GCFGlobal: Excel Tips – Working with Symbols
Discussion about this post