How to See All Available Font Characters Installed On Your System

Video Preview

Introduction

Using Microsoft Excel and a simple formula, you can see all the font characters available to you on your system. In addition, you can use the resulting worksheet information to learn the keyboard shortcut for the characters.

By: SeventhSibling

Length: 0:00

Comments: 1

View more articles by this author

Flag | RSS

Instructions

Text Size: +
Difficulty: Moderately Easy
Step1
=CHAR(ROW()) =CHAR(ROW()) In cell A1 of an open Excel worksheet, enter this formula: =CHAR(ROW())
Step2
Press enter and then copy or fill down the formula through the column until you get to cell A255. To fill down the formula, click in cell A1, drag the mouse down until you reach cell A255, release the mouse (cell A255 will be white surrounded by a black border while all the cells above will be highlighted), and then use Ctrl D to fill the formula down.
Step3
Column Selected Column Selected After filling the formula down, click on the Column A header to select the entire column.
Step4
Choose Font Choose Font Now, you can choose a different font. You can easily choose a different from the Font box on the formatting toolbar (highlighted in red in the image at the left) or you can choose a different font by clicking on Format in the top menu bar, then click on Cells, and finally, click on the Font tab. In your worksheet, scroll down to view the characters available. You can view other font characters by repeating Steps 3 and 4 where you select the column and then choose a different font.
Step5
Shortcut Key Shortcut Key To learn the keyboard shortcut for any character, look at the row number corresponding to the character. If the row number is less than two characters, add a zero to the front. Then, to perform the shortcut, hold down on the Alt key and press the corresponding numbers on the number pad on the right side of keyboard. In the example at left, the shortcut would be Alt 037. The receiving cell for your shortcut must be formatted with the same font setting.

Comments

| View All Comments
Flag This Comment

on 4/29/2008 This is great, thanks a bunch! 5 stars!

Post a Comment

POST A COMMENT

Request a New How-To Video Article

Looking for more How To information? Chances are there’s an eHow member who knows how to do what you’re looking to do. Submit an article request now!

eHow Article: How to See All Available Font Characters Installed On Your System

Article By: SeventhSibling

SeventhSibling

Authority Authority | 28130 Points

Category: Computers

Articles: See my other articles

Related Ads