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:
- Activate Excel’s Insert menu.
- Click Text Box in the Text section.
- Hold down your left mouse button and draw a rectangle on your worksheet.
- 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.
About David Ringstrom, CPA
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.