How to insert bullet points in text box or specify cells in Excel?
This tutorial is talking about 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: Download and try itnow! (30-day free trail)
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. Put the cursor in the cell (double click on the cell) in which you will insert the bullet.
2. Hold the Alt key, press the 7 key, and then leave 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
Besides, the Insert Symbol option can help to insert bullet points in Excel.
1. Put the cursor in the cell (double click on the cell) in which you will 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
May be the above methods are not convenient in most of the time. Here introduce an awesome feature for you. With the Insert Bullet utility of Kutools for Excel, inserting bullet points in cells is as easy as creating bullet list in Word.
Before applying the feature, please download and install it firstly.
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.
If you want to have a free trial (60-day) of this utility, please click to download it, and then go to apply the operation according above steps.
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.
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns and Keeping Data; Split Cells Content; Combine Duplicate Rows and Sum/Average... Prevent Duplicate Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Favorite and Quickly Insert Formulas, Ranges, Charts and Pictures; Encrypt Cells with password; Create Mailing List and send emails...
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- Pivot Table Grouping by week number, day of week and more... Show Unlocked, Locked Cells by different colors; Highlight Cells That Have Formula/Name...
- 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!
