You are currently offline, waiting for your internet to reconnect

XL: How to Create a Bullet List in Microsoft Excel

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

For a Microsoft Excel for Macintosh version of this article, see 125724.
Summary
Microsoft Excel does not have a built-in function to add a bullet itemto entries in a worksheet. However, you can add bullets to text, or you can create a custom text format that includes bullets, so that you can format the cells and add text later.
More information

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 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.
Text that you type in cells that are formatted with this custom format will have the bullet applied to them.
References
For more information about extended characters, click Start, point to Programs, point to Accessories, point to System Tools, and then click Character Map.
 XL2003 XL2007 XL2010
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.
Properties

Article ID: 323567 - Last Review: 09/23/2015 07:39:00 - Revision: 5.0

  • Microsoft Office Excel 2003
  • Microsoft Office Excel 2007
  • Microsoft Excel 2010
  • Excel 2016
  • Microsoft Excel 2013
  • kbhowto KB323567
Feedback
t" src="https://c.microsoft.com/ms.js">