Show check mark for "Done" in Excel
Related Videos: "Think About What We've Done" | When Panel Shows Break Down | 8 Out of 10 Cats Part 2 (May 2024).
You want to put a check mark for completed entries in an Excel table. The detour by copying the character from Word's special characters dialog is too cumbersome for you.
Create a check mark using the Excel system font
You can access this check mark fairly quickly in all applications. It is in fact stored in the TrueType system font "Marlett". This font is installed by default because Windows itself uses some of the characters it contains as an arrow in the Start menu, for example.
- To insert the checkmark, enter a small "a" in the document and mark it.
- Change the font either in the corresponding field on the ribbon at the top or right-click on the cell and then go to "Format cells".
- Activate the "Font" tab and then select the "Marlett" setting in the "Font" combo box.
- After clicking on "OK", the check mark you are looking for appears. You can also format an entire column in this way - a checkmark appears automatically when you enter the letter "a".
The "Marlett" font contains numerous special characters, such as the small triangular arrows used by Windows in the Start menu: you only have to enter "3", "4", "5" or "6" and then change the font as described.
Become an Excel professional with the new course at the CHIP Academy
With the course in the CHIP Academy "Excel: Pivot tables in less than an hour" even beginners learn how to handle a large amount of data quickly and easily.
- Learn in 40 minutes from our lecturer Daniel Kogan what pivot tables are and how to use them sensibly.
- You will learn how to use pivot tables and pivot charts to gain insights and insights from your data that you would otherwise not have been able to access.
- Visit the CHIP Academy and get the extensive online video workshop for 19.90 euros.
You can also create a tick in Excel with the "Wingdings 2" font. How this works is described here using Word as an example.