Bullet Points Using Excel


Posted by Bill W. on July 11, 2001 7:37 AM

Does anyone know if it is possible to use bullet points in excel like the way they are used in Word?

Posted by JAF on July 11, 2001 8:46 AM

It is possible to create the illusion of bullet points, but not to do "real" bulet points (at least, if you can I don't know how to!)

To create fake bullett points, you need to type a "spare" character and a space at the beginning of your cell contents (eg "a this is a text string"), then, in the formula bar, highlight the first character and change it's font to Wingdings (or similar)

A bit long winded if you have lots of cells to do, although I suppouse you could create macro to add a character at the beginning of each cell in a selected range and format it appropriately.



Posted by Bill W on July 11, 2001 9:04 AM