Thursday, September 9, 2010

How do you create bullet points in Microsoft Excel 2007?

How can you do bullet points in Excel similar to those in Microsoft Word? There are at least six methods that I know of:

1. =CHAR(149)

2. Alt+0149

3. Alt+249

4. The lower case letter n in Wingdings font

5. You can also import them from Word or use the character map (char.exe)

6. VBA code line: ActiveCell.Value = "•"

There may be others that I haven't thought of yet. Any suggestions?