Is it possible to insert bullets into an excel document?

M

Meenie

Other than using the drawing toolbar and trying to resize and move the object
into place, that is? :)
Thanks, Meenie
 
D

Dave F

The only way I know of is to go to Insert--Symbol and scroll through all the
font's characters until you find it. There probably is a keyboard shortcut,
since it is a font symbol, however, I've never undertood those keyboard
shortcuts. Perhaps someone else knows how to use the keyboard to get the
symbol to appear.

Dave
 
M

Meenie

Thanks, Dave, this might not be the penultimate answer, but it's got to be
better than what I was trying to do! :)
 
G

Gord Dibben

Meenie

Alt + 0149(on the numpad)will enter a bullet.

Note: Alt + Enter will give you a carriage return in the cell.

i.e. Alt + 0149 type some text then Alt + Enter. Alt + 0149 then more text.


Gord Dibben MS Excel MVP
 
J

JMB

Also, you could put Gord's keyboard shortcut in a macro in your personal
macro workbook and assign it to a custom button on your toolbar.

Sub Bullet()
Selection.Value = "•"
End Sub
 
Top