Common terms in Excel [Format Cells PART 4]

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

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
shift-p.png (1.92 KiB) Viewed 534 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
wingdings-2-font.png (2.34 KiB) Viewed 534 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
center-check-mark.png (2.6 KiB) Viewed 534 times

Result. A check mark in Excel.
check-mark.png
check-mark.png (1.97 KiB) Viewed 534 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
red-x.png (1.99 KiB) Viewed 534 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
check-marks.png (5.24 KiB) Viewed 534 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
click-symbol.png (3.88 KiB) Viewed 534 times
7. Select Wingdings 2 from the drop-down list, select a check mark and click Insert.
insert-check-mark.png
insert-check-mark.png (15.51 KiB) Viewed 534 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

www.i-metrik.com

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