MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Bullets in Excel


Posted by John on January 23, 2002 9:51 AM

Does anyboy know of a way to create a simple circular bullet in excel and be able to a adjust size and color.

I tried looking at autoshapes and symbols - but nothing was available - I'm using excel 97.

Thanks.


Posted by Tanya on January 23, 2002 10:27 AM

I try to avoid using bullets in Excel. But, when I do use them, I create the bullet in Word (using insert-symbol) and then paste it into Excel. If you paste into the column just to the left of your data and right align it, it looks pretty good.

Posted by Jo on January 23, 2002 11:01 AM

I'm fairly new to Excel, but can't you create a new column and use the =CHAR(149) or =CHAR(186)
to create the bullet? Sorry if I'm wrong..

Posted by Tom Urtis on January 23, 2002 11:30 AM

Here are two ways to do it

To create a bullet manually, press the Alt key and simultaneously enter 249. Let go of the Alt key and press Enter.

The VBA line of code for that is
ActiveCell.Value = "•"

From there you can edit the cell by selectively formatting that (or any other character) for size and color, which of course VBA can also handle if you prefer.

The bullet looks kind of "Square-ish" in 10 point on the monitor screen, but in a larger font size appears more circular. It will print "circular-shaped" regardless of the font size.

HTH

Tom Urtis

Posted by AB on January 29, 2002 5:47 AM

Hold down the ALT key and press the number 7 on the keypad. This works across multiple platforms including Excel.