Showing posts with label Create a Bullet List in Microsoft Excel. Show all posts
Showing posts with label Create a Bullet List in Microsoft Excel. Show all posts

Monday, January 7, 2008

How to Create a Bullet List in Microsoft Excel

To Add a Bullet to an Existing Text Entry

1.Position the insertion point at the beginning of your text entry.
2.Type a symbol that you want to use as a bullet. To create the bullet character, press ALT+0149 (type 0149 on the numeric keypad).

You may want to include a space after the character so that the bullet will not be next to the text. Note that the bullet is an extended character and may not be available with all fonts.

Some other examples of characters you can use include: >, /, ~, !, and others.


To Create a Custom Text Format That Includes Bullets

1.Select the cell or range of cells that you want to apply bullets to.
2.On the Format menu, click Cells.
3.On the Number tab, click the Text category, and then click the Custom category.

Microsoft Excel places an at sign (@) in the Type box.
4.In the Type box, place the insertion point before the @, and type the symbol that you want to use as a bullet. To create the bullet character, press ALT+0149 (type 0149 on the numeric keypad).

You may want to include a space after the symbol so that the bullet will not be next to the text. Note that the bullet is an extended character and may not be available with all fonts.

Some other examples of characters you can use include: >, /, ~, !, and others.
5.Click OK.