To add a bullet to text in a cell, create the bullet by using its American National Standards Institute (ANSI) code. You can enter this character by copying the character from the Character Map program that is included with Windows, or by entering a keystroke combination. To enter a keystroke combination, hold down ALT and type a four-digit number on the numeric keypad. Note, you cannot type this number from the number keys at the top of the keyboard.
If you are using the Times New Roman font, the keystroke for the bullet character is ALT+0149. To create the bullet, click the cell, hold down ALT and type
0149 on the numeric keypad.
If you don't know the ANSI code for the bullet character or you want to use a different bullet character, you can determine the character code or insert the character by using the Character Map program. To do this, follow these steps.
NOTE: Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.
- Click Start, point to Programs, point to Accessories, point to System Tools, and then click Character Map.
- In the Font list, select the font that you are using to format the text in Excel.
- In the table, click the bullet character. Note the keystroke combination that appears in the lower-right corner of the Character Map dialog box.
- At this point you can do one of the following:
- Copy the character. To do this, click the symbol, click Select, and then click Copy. Switch to Excel and then click Paste on the Edit menu.
-or- - Switch to Excel and type the keystroke.
- In Character Map, click Close.
NOTE: You can also apply a custom format in Microsoft Excel that uses the bullet symbol.
For additional information about how to do this, click the article number below
to view the article in the Microsoft Knowledge Base:
323567�
XL: How to Create a Bullet List in Microsoft Excel