Harkem (one of my 12 fans) wrote me recently and asked:
“How can I use bullet points in Excel? Much of my PowerPoint presentations are made of Excel ranges that are copied and pasted as pictures. I remove the gridlines to make it look seamless in PowerPoint. I’d like to be able to use bullet points in Excel to enhance the illusion.”
Well Harkem, you’ve come to the right place. I happen to know the answer.
Let’s say I want to add bullet points to this list of topics. I could manually type in some asterisks or dashes, but that would be tedious and ugly.
There is a better way.
Step 1: Find a symbol and insert somewhere in your workbook
The first step is to find the symbol that would make an appropriate bullet point. Here I’ll choose a diamond.
After you choose the symbol, insert it into any empty cell in your worksheet.
Step 2: Copy the symbol
Highlight the inserted symbol and press Ctrl+C on the keyboard to copy the symboal.
Step 3: Add a Custom Number Format to the target text
Highlight the range of cells you would like the bullet points to be applied, right-click, and then choose Format Cells.
The Format Cells dialog box, you’ll add your own custom format.
Here, entered the diamond by pasting the copied symbol. I followed it with a space, then the “at” symbol (@).
After you confirm the custom number format, you’re bullet point will be applied to your text.
The benefit of using this technique is that you can edit the text and Excel will automatically place your bullet point.
Plus, you can copy the format to any range of cells to apply the same bullet points.
I’ve gone crazy and added all kinds of bullets to my list. I’m living the dream.
There you go Harkem. Now send me some cookies or bacon.