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.