Three Ways to Create Bulleted Lists in Microsoft Excel

Spreadsheets and graphs on a desk

You’ve likely used the Bullets command in Microsoft Word to create a bulleted list of items, but you may not realize that it’s possible to create such lists in Excel as well.

In this article, I’ll compare using text boxes versus using a number pad trick to create in-cell bullet symbols. I find that many users rely on merged cells within a spreadsheet to store a paragraph or more of text, but personally, I find text boxes are far superior for this purpose.

Let’s first create a text box, as shown in Figure 1:

  1. Activate Excel’s Insert menu.
  2. Click Text Box in the Text section.
  3. Hold down your left mouse button and draw a rectangle on your worksheet.
  4. Once you release the mouse, you can type in the text box in the same fashion as you would a Word document or email message.

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.

BONUS: If you register now you can opt to receive a digital copy of "Transform!" , Richard Francis' new book for growing firms [US/Canada ONLY].

About David Ringstrom, CPA

David Ringstrom

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. His mantra is “Either you work Excel, or it works you.” David offers spreadsheet and database consulting services nationwide.


Please login or register to join the discussion.

May 8th 2018 09:20

great read. Excel is indeed a powerful tool but we at times are not utilising it to the fullest.

Thanks (1)