How to Add Bullets in Excel Cell (10 Quick Ways)

Bullets are very useful symbols to represent certain lists or tables. In Microsoft Word, we are familiar with bullets, but in Excel, it is possible to add bullets as well. In this article, we will go through the process of how to add bullets in the excel cell in 10 quick ways.


Download Workbook

Download this sample file to practice by yourself.


10 Quick Ways to Add Bullets in Excel Cell

Let us take an example to describe the process. Here is a dataset showing the obtained marks of 5 students in a school.

How to Add Bullets in Excel Cell


Now, we will insert bullets beside the names to make it more signified.

1. Add Bullets in Excel with Keyboard Shortcuts

Keyboard shortcuts are the quickest method to add bullets to cells. Follow these simple steps:

  • First, select cell B5.
  • Then, press Alt + 7 or Alt + 0149 on your keyboard.
  • That’s it, you will get a bullet in the selected cell.

Add Bullets in Excel with Keyboard Shortcuts

  • Now drag the bottom corner of cell B5 up to cell B9 to get bullets in all cells.

Add Bullets in Excel with Keyboard Shortcuts


2. Use Symbol Dialogue Box for Inserting Bullets

We will insert bullets with the Symbol dialogue box. Let’s see how it works:

  • First, double-click on cell B5 to point out the location of the bullet.

Use Symbol Dialogue Box for Inserting Bullets

  • Then, go to the Insert tab and select Symbols.

Use Symbol Dialogue Box for Inserting Bullets

  • Now, select the type of bullet of your preference from the Symbol window.
  • Then, press Insert.

Use Symbol Dialogue Box for Inserting Bullets

  • Finally, you got a bullet symbol in the selected cell.

Use Symbol Dialogue Box for Inserting Bullets

  • Apply the same procedure in cell range B6:B9 to get the final output.

How to Add Bullets in Excel Cell


3. Copy Bulleted List from Microsoft Word to Excel

If you have the names as bullet points in Microsoft Word then you can easily get them in excel by following these steps:

  • First, select all the texts in your Word file.
  • Next, press Ctrl + C on your keyboard to copy them.

Copy Bulleted List from Microsoft Word to Excel

  • Then, go to your Excel file.
  • Here, select the cell range B5:B9.
  • Following, press Ctrl + V on your keyboard.
  • That’s it, you got bullets imported from your Microsoft Word file.


4. Apply CHAR Function to Add Bullets in Excel Cell

In this method, we will apply the CHAR function to add bullets. For this, you need to have a preset dataset for reference. Now let’s see the steps below:

  • First, insert this formula in cell C5.
=CHAR(149)&" "&B5

Apply CHAR Function to Add Bullets in Excel Cell

  • Then, press Enter.
  • Here, you got the first item bulleted.

Apply CHAR Function to Add Bullets in Excel Cell

  • Lastly, use the AutoFill tool to apply the formula in cell range C6:C9.


5. Insert Special Fonts to Add Bullets

We can also insert bullets into excel cells by using a special font. Let’s go through the process:

  • In the beginning, double-click on cell B5 to define where you want the bullet.
  • Then, select the font Wingdings from the Font list in the Home tab.

Insert Special Fonts to Add Bullets

  • Now, press L on your keyboard.
  • Finally, you got the bullet inside the selected cell.

Insert Special Fonts to Add Bullets

  • Follow the similar process for cell range B6:B9.

Insert Special Fonts to Add Bullets


6. Add Bullets in Excel Cell Creating Custom Format

In this method, we will format the cells to add bullets. Go through the following process:

  • In the beginning, select the cell range B5:B9.
  • Then, right-click on it and choose Format Cells.

Add Bullets in Excel Cell Creating Custom Format

  • Now, in the new window, select Custom under the Number section.
  • Here, press the Alt + 7 key and then type @ in the Type box.
  • Otherwise, you can type • General;• General;• General;• General as well.
  • Following, hit OK

Add Bullets in Excel Cell Creating Custom Format

  • Finally, you can see bullets in the cells.


7. Insert Bullet Points in Text Box

In excel, we can work on a Text Box just like Microsoft Word and insert bullets in it. Simply go through the process below:

  • First, select cell B4.
  • Then, go to the Insert tab and click on Text.

Insert Bullet Points in Text Box

  • Here, choose Text Box from the drop-down section.

Insert Bullet Points in Text Box

  • Following, you can see a Text Box appearing on the selected sheet.

Insert Bullet Points in Text Box

  • Drag the corner of the box to adjust its size.
  • Now, right-click on it and go to the Bullets option.
  • From here, select the type of bullet you prefer.

Insert Bullet Points in Text Box

  • After that, you will see a bullet inside the box.
  • Lastly, type the student names and it will show like this:


8. Add Bullets in Excel Cell with SmartArt

SmartArt is a useful tool to add bullets to cells. Follow the steps here:

  • First, go to the Insert tab and select SmartArt.

Add Bullets in Excel Cell with SmartArt

  • Following, the Choose a SmartArt Graphic window pops up.
  • Here, go to List and select Vertical Bullet List.

Add Bullets in Excel Cell with SmartArt

  • After that, press OK.
  • Next, you can see the Type your text here box appears to type.

Add Bullets in Excel Cell with SmartArt

  • Here, type the student names and the final output will look like this:


9. Apply Excel VBA Macro to Add Bullets

The final technique is to apply Excel VBA Macro code to add bullets to excel cells. Let’s go through its steps.

  • In the beginning, select cell range B5:B9.
  • Then, go to the Developer tab and select Visual Basic.

Apply Excel VBA Macro to Add Bullets

  • Following, select Module from the Insert section in the new window.

Apply Excel VBA Macro to Add Bullets

  • After that, insert this code on the blank page.
Sub AddBullets()
    For Each Cell In Application.Selection
        Cell.Value = Chr(149) & " " & Cell.Value
    Next Cell
End Sub

Apply Excel VBA Macro to Add Bullets

  • Next, click on the Run Sub button or press F5 on your keyboard.

  • After that, select Run on the Macros window.

Apply Excel VBA Macro to Add Bullets

  • Finally, you will get bullets on your selected cells.


10. Insert Multiple Bullets in a Single Excel Cell

In this method, we will try to add multiple bullets in a cell. Let’s see how it works.

  • In the beginning, insert a bullet following any of the methods above in cell B5.
  • Then, type your required text in it.

Insert Multiple Bullets in a Single Excel Cell

  • Now, press Alt + Enter.
  • Following, you will be directed to the next line.
  • Here, again insert a bullet symbol and type your text.

Insert Multiple Bullets in a Single Excel Cell

  • Follow this process until you finish writing all your texts.
  • The final output looks like this:


Things to Remember

  • If your laptop does not have a number pad, then press Shift + Num Lock or Fn + Num Lock to enable Num Lock.
  • Use the Alt key while dragging the Text Box to align the box edges with cell borders.

Conclusion

I hope it was a helpful article for you on how to add bullets in excel cells in 10 quick ways. Get the sample file and try any of them. Let us know your feedback in the comment box. Follow ExcelDemy for other excel blogs.

Guria

Guria

Hello! Welcome to my blog. I have completed my Bachelor in Architecture from Ashanullah University of Science & Technology, Dhaka. I am a passionate, goal-oriented person with an immense thirst for knowledge and an attitude to grow continuously. Besides Architectural work, I find it very enthusiastic to work in Excel blogging. Exceldemy is a platform where I have got the opportunity to flourish my skill in Microsoft Excel and therefore, here I will be posting blogs related to it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo