Ways to insert check mark in excel
A free Office suite fully compatible with Microsoft Office
A free Office suite fully compatible with Microsoft Office
How to insert check mark in Excel? There are two types of check marks in Excel: mark symbol and check box. A check mark is a symbol that you can insert into a cell, either alone or in combination with another character.
A checkbox is a special control that will allow you to check or uncheck an option. If you want to know how to insert check mark in Excel, you will know the common ways to add such a symbol.
How to insert check mark in Excel by copying and pasting the check mark?
One of the most common and easy options of how to insert check mark in excel is to copy and paste the check mark. You have to follow the following steps:
1. Open the spreadsheet where you want to add the checkmark.
2. Copy the checkmark and go to the cell where you want to copy it.
3. Double click on the cell or press the F2 key. This will take you to edit mode.
4. Pressing Control + V, you will paste the check mark in the selected cell.
5. Once you have the checkmark in your spreadsheet, you have to copy and paste as many times.
How to insert a check mark in Excel for Mac?
If you are using a Mac computer and you don't know how to insert check mark in excel Mac, please follow the steps below:
1. Open the Excel document on your Mac computer
2. Select the cell where you want to add the checkmark.
3. Hold down the option key + 0252 (use the numeric keypad).
How to insert a check mark symbol with a keyboard shortcut?
Below you will know how to insert check mark in Excel shortcut. You can use the following shortcuts:
1. Hold down the Alt key, press 0252 using the number pad, and release the Alt key.
2. You can also use the Alt + 0254 key. You will be able to insert the check mark with a box. You need to hold Alt + 0254 using the Numpad, then release Alt.
3. It is important that when using this method to insert a check mark, you change the font format to Wingdings.
How to insert a check mark using the Symbols dialog?
How to insert check mark in Excel? Another option you can use to add a check mark is by using the Symbol dialog.
1. Select the cell where you want to add the check mark symbol.
2. Click on the Insert tab on the ribbon.
3. Then click on the Symbol icon.
4. When you are in the Symbol dialog, you should select Segoe UI Symbol as the font.
5. Scroll down so you can find the check mark symbol you want and click on it.
Have you learned how to insert check mark in Excel? With any of the methods mentioned above, you will be able to add a check mark to your Excel document. If you want to learn more about this topic or learn more about Excel, you can search for WPS Academy.
In addition, you will have the opportunity to download the WPS Office software to create and process documents in Excel, PowerPoint, and Word for free. It gives you a better working experience, and you will learn important new functions.
Was this helpful?
Yes
No
Trending Tutorials
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to color cell based on value in Excel?
- 5. How to compare two excel sheets and highlight differences
- 6. How to add text to beginning or end of all cells in Excel