Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
How to insert a check mark into excel
There are many reasons you will want to know how to insert a check mark into excel in detail. Whether you want to check off some cells using a spreadsheet, communicate how work is going to your colleagues, or manage a list.
If you like to work constantly in Excel, you must learn to insert a checkmark into excel. So don't hesitate to seek advice from a friend who knows how this complete tool works.
Know more about how to insert a check mark into excel online.
How can you put a mark in excel using the symbol command?
Discover the most common way how to insert a check mark into excel using a symbol, don't miss it in a few steps
1. Select a cell where you are interested in inserting this type of check mark.
2. Then you must go to the Insert tab, then to symbols group, and click on the symbol.
3. Using the symbol dialog box, click on the dropdown arrow, where the Wingding font and selection box is.
4. You will be able to find several check mark symbols all over the bottom of the list. Choose the symbol of your choice and then click insert. To finish, click close.
How to insert a check mark into excel mac by writing all character code?
Another fairly quick way how to insert a check mark into excel is to write your code directly through a cell while holding down the Alt key.
1. To start, you have to choose the cell where you want to place a mark.
2. In the tab where it is home, in the font group, change it to Wingding.
3. Press and hold alternative while you are typing various codes on the numeric keypad.
SYMBOL |
CHARACTER CODE |
BRAND SYMBOL |
ALT+0252 |
CHECK ONE BOX |
ALT+0254 |
CROSS SYMBOL |
ALT+0251 |
CROSS IN A BOX |
ALT+0253 |
How should you insert a mark in excel if you use the CHAR function?
You must know everything related to how to insert a check mark into excel so that you learn to work correctly in Excel. To find out various steps if using CHAR function, and also you can learn what you want about how to insert a check mark into excel mac.
1. It is surely not the most convenient way for you to add a tick symbol in Excel. You must know various symbol codes specifically.
2. The formula for you to put a check mark is quite simple: = CHAR (252)
3. For you to add a cross symbol, you must use the following formula: = CHAR (253).
If you have benefited from the steps for how to insert a check mark into excel that you found in WPS Academy, you must stay tuned for new news that is trending in this type of program.
Once you know how to insert a check mark into excel, you will see that it is a very simple procedure, and you can improve it by adding columns that suggest that your tasks have been completed.
You will be able to seamlessly download and use the ideal WPS Office software to process and create Excel, Word, and PowerPoint documents for free.
Also Read:
- 1. How to insert check mark in excel
- 2. How to add a check mark in excel (2 Easy Methods)
- 3. The best AI Spelling and Grammar Check tool - WPS Office AI Spell Check
- 4. How to check if value exists in a range in Excel
- 5. Free Downloadable Business Check Printing Template Excel
- 6. Quickly insert a box with check mark in WPS Office Excel