×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Microsoft: Office FAQ

Tips and Tricks

Bulleted Lists in Excel by xlhelp
Posted: 6 Jul 09 (Edited 6 Jul 09)

Bullet in a single cell:

This one is easy. Most people know about this one.

Place your cursor at the beginning of the cell; hold the ALT key and on the numeric keypad only, enter 0149.

Inserting bullets in multiple cells:

Using a Formula:

This needs to be done in another column with a formula.  If, for example,  the text you want bulleted is in column C; then taking cell C2 as our reference we would write a formula in cell D2 –
=CHAR(149)&C2)
and copy down as far as you wish. You now have a bulleted list in Column D. Highlight the bulleted cells in Column D; Copy; select cell C2, and using Paste Special, paste Values. Delete the bulleted list in column D.

If you want a space between the bullet and the text, change the formula to
=CHAR(149)&" "&C2).
Note: There is a space between the two quotation marks.

Using Custom Formatting

Highlight the cell(s) that will have bulleted text. Go to Format, Cells, Number Tab. Under Categories, choose Text first and then choose Custom. Place your cursor before the @ sign in the Type: box. Hold the ALT key and on the numeric keypad only, enter 0149. (if you want a space between the bullet and the text, type in the space after entering 0149). Click OK to accept the Custom Format.

Inserting multiple bullets in a single cell:

(Please note:- This method works only if you have less than 1024 characters in the cell. Else, you will get an error "Formula is too long")

Type your list(s) in the cell(s) the as you need using ALT/ENTER to create each new line in the cell. Once you have typed in all your data, go to Edit, Replace. The Find and Replace dialog box will pop up. Place your cursor in the Find what: box and hold the [b][blue]ALT key and on the numeric keypad only, enter 0010. Let go of the ALT key. Place your cursor in the [b][blue]Replace with: box and Hold the ALT key and on the numeric keypad only, enter 0149. Let go of the ALT key and type in a space if you wish to have a space after the bullet. In the Replace with: box, place your cursor just before the bullet; hold the ALT key and on the numeric keypad only, enter 0010. Let go of the ALT key. Click Replace All on the Find and Replace dialog box and your list(s) will be populated with bullets except for the very first line. You can add the bullet to the first line using the method described above for "Bullet in a single cell".
 

Back to Microsoft: Office FAQ Index
Back to Microsoft: Office Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close