Common terms in Excel [Format Cells PART 4]

User avatar
Site Admin
Posts: 9
Joined: 05 Apr 2020, 03:06
Location: PTP Nagar, Trivandrum

Common terms in Excel [Format Cells PART 4]

Postby Administrator 10 Apr 2020, 19:14

Check Mark
To insert a check mark symbol in Excel, simply press SHIFT + P and use the Wingdings 2 font. You can also create a check list that uses check boxes.

1. Select cell A1 and press SHIFT + P to insert a capital P.
shift-p.png (1.92 KiB) Viewed 533 times

2. On the Home tab, in the Font group, select the Wingdings 2 font. To insert a fancy check mark, change the font color to green, change the font size to 12 and apply bold formatting.
wingdings-2-font.png (2.34 KiB) Viewed 533 times

3. On the Home tab, in the Alignment group, use the Align buttons to center the check mark horizontally and vertically.
center-check-mark.png (2.6 KiB) Viewed 533 times

Result. A check mark in Excel.
check-mark.png (1.97 KiB) Viewed 533 times

4. To insert a fancy red X, press SHIFT + O to insert a capital O and change the font color to red.
red-x.png (1.99 KiB) Viewed 533 times

5. Now you can create a nice to-do list that uses check marks. Use CTRL + c and CTRL + v to copy/paste a check mark or red X.
check-marks.png (5.24 KiB) Viewed 533 times
Instead of executing step 1 and 2, you can also use the Insert tab to insert a check mark symbol. Here you can find other symbols as well.

6. On the Insert tab, in the Symbols group, click Symbol.
click-symbol.png (3.88 KiB) Viewed 533 times
7. Select Wingdings 2 from the drop-down list, select a check mark and click Insert.
insert-check-mark.png (15.51 KiB) Viewed 533 times
Note: you can also insert a check mark symbol with a box around it (see picture above). After inserting one check mark, you can use the Recently used symbols to quickly insert another check mark.
Thanks & Regards
Saran BL

Was This Topic Useful?

Last 10 Members Who Visited This Topic

Zelenawtd, Regaembaf, PutinLak, User avatar Administrator

Return to “Basic Excel Training”

Who is online

Users browsing this forum: No registered users and 1 guest