Create a Bulleted List in a Cell (Excel 2007)

It is very easy to create a bulleted list in Word or PowerPoint. All you have to do is to click the Bullets button in the Paragraph group (under the Home tab). But you couldn’t do the same in Excel because there is no Bullets button that you can instantly click on. Well, I’ll show you how to do it in a few simple steps.

1.  Double-click on a cell to make it editable.


 2.  Click the Insert tab and select the Symbol button on the far end corner of the tab.


3.  A Symbol dialog box appears. Depending on the setting of your computer, the symbols may appear different from what you see in the dialog box below.


Select a bullet symbol and click the Insert button. As soon as you click the Insert button, the Cancel button next to it will automatically changed to Close. Click to close the dialog box.

4.  A bullet is inserted into the cell. Type your text next to the bullet.

5.  You can copy and paste the bullet to make a list of items in the cell such as this. Remember to create a line break within the same cell to insert each bullet in a new line.


Leave a Reply

Your email address will not be published. Required fields are marked *