Add Bullet Points in Excel Text Box (with 4 Suitable Ways)

Get FREE Advanced Excel Exercises with Solutions!

Bullet points are extremely handy when creating a list. You can record the list items through bullet points very easily and quickly. Besides, a text box is another special tool for recording a long text or paragraph in a single text area. Now, it might be needed frequently that you need to put bullet points inside your text box. In that case, you have landed in the right place. In this article, I will show you 4 easy ways to put bullet points in an Excel text box.


Download Practice Workbook

You can download and practice from our workbook here for free!


4 Ways to Add Bullet Points in Excel Text Box

Suppose you have inserted a text box where you have a list of four tasks. Now, you need to put bullet points inside the text box. You can follow any of these 4 simple ways to do this.

Items in Excel text box


1. Add Bullet Points in Excel Text Box from Right-Click Context Menu

You can simply put bullet points inside a text box using the right button of the mouse. Follow the steps below to accomplish this.

📌 Steps:

  • First and foremost, select all the items on your list by dragging your mouse.

Select the items in a text box to put bullet points

  • Afterward, click the right button on your mouse. Subsequently, choose the Bullets option’s rightward arrow >> Filled Round Bullets option.

Choose bullets options to put bullet points in Excel text box

Thus, you will have the items in filled round bullets. And the result should look like this. Besides, You could have chosen the Hollow Round Bullets option here too.

Bullet points in Excel text box


2. Using a Keyboard Shortcut

You can also use a keyboard shortcut to put bullet points individually to your items. Follow the steps below to do this.

📌 Steps:

  • At the very beginning, place your cursor before any item. Subsequently, press Alt+ Num 7.

Use keyboard shortcut to put bullet point in text box

Note:

  • Make sure your Num Lock is switched on when doing this.
  • Press Alt + Num 4 to put a hollow round bullet.
  • As a result, you can see there is a filled round bullet point beside the first item.

One bullet point in text box

  • Similarly, place your cursor before each item and press Alt + Num 7.

Consequently, you will get the bullet points for each item. And, the outcome should look like this.

Bullet points in Excel text box


3. Utilizing Excel Symbols Command

Moreover, you can use the Symbol dialogue box to insert bullet points in the items of a list. Go through the steps below to achieve this.

📌 Steps:

  • Initially, select any of the items on your list inside the text box. Next, go to the Insert tab >> Symbols tool >> Symbol option.

Open the Symbol dialogue box

  • At this time, the Symbol dialogue box will appear. Choose the bullet symbol from the symbol list and click on the Insert button.

Insert symbol from Symbol dialogue box

  • As a result, there will be a bullet point beside your list item inside the text box.

One bullet point in text box

Similarly, you can follow these steps for all the items on your list. And, the final outcome should look like this.

Bullet points in Excel text box


4. Direct Copy Bullet Points and Paste in Text Box

Another way to put bullet points in an Excel text box is to copy and paste bullet points from an external source. Follow the steps below to accomplish this.

📌 Steps:

  • First, copy your desired bullet point from some external source.
  • Second, place your cursor before any item on the list.

Place cursor to put bullet point

  • Next, click your right mouse button and choose the first option under the Paste Options: option from the context menu.

Paste bullet point

  • As a result, you can see that there is a bullet point beside the item on the list.

One bullet point in text box

Similarly, repeat these steps for all the items and put bullet points before every item on the list. And, the outcome should look like this.

Bullet points in Excel text box

Note:

You can also press Ctrl + V instead of right-clicking the mouse.

Read More: Excel Bullets and Numbering Greyed Out (Reason & Solution)


Conclusion

To conclude, in this article, I have shown you 4 quick ways to add bullet points in an Excel text box. I would suggest you go through the full article carefully and practice thoroughly. You can also download our practice workbook from here for free. I hope you find this article helpful and informative. If you have any further queries or recommendations, please feel free to comment here.
And, visit ExcelDemy for many more articles like this. Thank you!


Related Articles

Tanjim Reza
Tanjim Reza

Hello! I am Md. Tanjim Reza Tanim. I have just completed my B.Sc from Naval Architecture & Marine Engineering Department, BUET. Currently, I am working as an Excel & VBA content developer. I always had a great fascination with Microsoft Excel and its cool functions and formulas. Here, I am learning every day about new functions and formulas and working on applying MS Excel to the analysis of our real-life problems. I have great enthusiasm for learning any kind of new things, writing articles, and solving real-life problems.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo