How to insert bullet points in text box or specific cells in Excel?
This tutorial explains how to insert bullet points in a text box or multiple cells in Excel.
Insert bullet points in cells in Excel
Method A: Insert bullet points in cells with the Format Cells feature
Method B: Insert bullet points in cells with Shortcut
Method C: Insert bullet points in cells with the Insert Symbol feature
Method D: Insert bullet points in cells with formula
Quickly insert bullet points in cells with an awesome feature
Insert bullet points in text box in Excel
This section will show you how to insert bullet points in a text box in Excel. Please do as follows.
1. Select and right click the texts in the text box, click Bullets in the context menu, and then choose the bullet as you need.
Now bullet points are added before each row text in the text box.
Only several clicks to insert bullet points in selected cells at once:
The Insert Bullet utility of Kutools for Excel helps you quickly insert bullet points in cells of a range or multiple ranges quickly with only several clicks. See the below demo:
Kutools for Excel - Supercharge Excel with over 300 essential tools. Enjoy permanently free AI features! Get It Now
Insert bullet points in cells in Excel
Supposing you need to insert bullet points in a list of cells, here provides several methods for you to achieve it.
Method A: Insert bullet points in cells with the Format Cells feature
1. Select all cells you will insert bullet points in, right click and select Format Cells from the context menu.
2. In the Format Cells and under the Number tab, click Custom in the Category box, copy the below content into the Type field, and click the OK button.
• @
Then bullet points are added in selected cells as below screenshot shown.
Method B: Insert bullet points in cells with Shortcut
The shortcut Alt + 7 can also help to insert bullet point in cell. Please do as follows.
1. Place the cursor in the cell (double-click the cell) where you want to insert the bullet.
2. Hold the Alt key, press the 7 key, and then release the Alt key to show the bullet.
Note: You need to repeat the shortcut until bullet points are inserted in all cells.
Method C: Insert bullet points in cells with the Insert Symbol feature
Alternatively, the Insert Symbol option can help you add bullet points in Excel.
1. Place the cursor in the cell (double-click the cell) where you want to insert the bullet.
2. Click the Symbol button under the Insert tab.
3. In the Symbol window, select General Punctuation in the Subset drop-down list, find and select the • symbol, and then click the Insert button to insert the symbol in cell.
Note: You need to repeat the steps until bullet points are inserted in all cells.
Method D: Insert bullet points in cells with formula
Use the CHAR function can help to add bullet points in a list of cells.
1. Select a blank cell, copy the below formula into it and press the Enter key. Select the result cell and drag the Fill Handle down to apply the formula to other cells.
=CHAR(149)&" "&B4
If you want to know more about the CHAR function, please visit here…
Quickly insert bullet points in cells with an awesome feature
The above methods may not always be convenient. Here’s an awesome feature for you: with the Insert Bullet utility of Kutools for Excel, inserting bullet points in cells is as easy as creating a bulleted list in Word.
1. Select the list of cells in which you want to insert bullet points, click Kutools > Insert > Insert Bullet. Then choose a bullet type from the submenu.
Then bullet points are added in selected cells.
Kutools for Excel - Supercharge Excel with over 300 essential tools. Enjoy permanently free AI features! Get It Now
Related articles
Allow only numbers to be input in text box
If you want to allow only numbers to be typed into a text box, the method in this article will do you a favor
Automatically resize the text box to fit the content in Excel
The text box size is fixed after inserting it in a worksheet. So the size won’t adjust to fit the text you inserted or deleted. This article aims to show you methods of automatically resizing the text box to fit the content in Excel.
Find and replace specific text in text boxes
This article provides the VBA method in detail to help you find and replace texts in text boxes only.
Insert picture into text box in Excel
By default, we can insert a picture or image into a worksheet as quickly by using the Insert function, but, this feature is not applied to inserting a picture into a textbox. With this article, you will learn how to insert a picture into a textbox as you need.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in