Add Multiple Bullet Points in Excel Cell (5 Suitable Ways)

Bullet points are very common in MS Word. But in Excel, we do not have any built-in option to insert bullet points. It is very tricky to insert bullet points in Excel. But inserting multiple bullet points in a cell in Excel is very complex. This article will teach us how to insert multiple bullet points in a cell in Excel.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


5 Ways to Add Multiple Bullet Points in Excel Cell

In this article, we will explain 5 different methods to insert multiple bullet points in a cell in Excel. We have multiple names in a single cell. We will add bullet points with each line of that cell.


1. Add Multiple Bullet Points in Excel Cell by Applying Symbol Command

We will add bullet points with each line in Excel using the symbol feature.

📌 Steps:

  • We add a column in the dataset to present data with bullet points.

  • Now, place the cursor on Cell C5.
  • Click on the Insert tab.
  • Press the Symbol option from the Symbols group.

Add Multiple Bullet Points Utilizing Symbol Feature

  • Now, the Symbol window appears.
  • Choose Bullet sign of Character code 2022.
  • Then, press the Insert button.

Add Multiple Bullet Utilizing Symbol Feature

  • Finally, press Close.

We can see the bullet symbol on that cell.

  • Add the first name.

  • After that, add a line break by pressing Alt + Enter.

Add Multiple Bullet Utilizing Symbol Feature

  • Add the bullet symbol and the rest of the names one by one.


2. Using a Keyboard Shortcut from a Numeric Keypad

We will use a keyboard shortcut to add multiple bullet points in a cell. For this, we need to have a numeric keypad on the right side of our keyboard.

📌 Steps:

  • First, go to Cell C5.
  • Double click the mouse right button.

  • Now, press Alt + 7.

Keyboard Shortcut from a Numeric Keypad for bullet points in a cell

We can see a bullet point is added here.

  • Add the first data after the bullet point.

Keyboard Shortcut from a Numeric Keypad for bullet points in a cell

We can see a line with a bullet point.

  • Now, add a line break by pressing Alt + Enter.

A new line started here.

  • Repeat the process of adding bullet points and add the rest of the lines.


3. Using CHAR Function

The CHAR function returns characters specified by the code number from the character set from your computer. In this section, we will insert bullet points using the CHAR function.

📌 Steps:

  • Go to Cell C5.
  • Put the formula below.
  =CHAR(149)

Excel CHAR Function for multiple bullet points

  • Now, press the Enter button and look at the dataset.

A bullet point is added here.

  • Now, add the first data using the ampersand symbol in the existing formula. Formula becomes:
  =CHAR(149)&" Jessica"

Excel CHAR Function for multiple bullet points

  • We can see the first data with the bullet point.

  • After that, we will add a line break using the CHAR function with the corresponding code of the line break. 10 is the code that stands for the line break.
  • So, the modified formula becomes.
=CHAR(149)&" Jessica"&CHAR(10)&CHAR(149)

Excel CHAR Function for multiple bullet points

  • And the result is here.

  • Similarly, we add all the data into the formula, which looks like this.
=CHAR(149)&" Jessica"&CHAR(10)&CHAR(149)&" Henderson"&CHAR(10)&CHAR(149)&" Aaron"&CHAR(10)&CHAR(149)&" Mitchel"&CHAR(10)&CHAR(149)&" John"

Excel CHAR Function for multiple bullet points

  • So, the final result is here.


4. Using Copy and Paste Command

In this section, we will copy the bullet symbol from MS word and paste it into Excel.

📌 Steps:

  • First, go to MS Word and copy the bullet symbol.

  • Now, back to the Excel file.
  • Paste the bullet symbol by pressing Ctrl + V.

Copy and Paste Command for multiple bullet points

  • Write the first data after the bullet symbol.

Copy and Paste Command for multiple bullet points

  • Now, add a line break by pressing Alt+ Enter and again paste the bullet symbol.

  • In this way, write the rest of the data.


5. Excel VBA Macro to Add Multiple Bullet Points

In this section, we will apply an easy VBA code that easily adds multiple bullet points in an Excel cell.

📌 Steps:

  • Go to the Sheet Name section, at the bottom of each sheet.
  • Press the right button of the mouse.
  • Choose View Code from the Context Menu.

Excel VBA Macro for Multiple Bullet Points

  • We entered the VBA application window.
  • Press the Insert tab.
  • Choose the Module option from there.

Excel VBA Macro for Multiple Bullet Points

  • Finally, the VBA module appears where we put the VBA code.

  • First, select the cell.
  • Now, put the following VBA code on the module.
Sub Add_Bullet_Points()
    Dim range_1 As Range
    Dim text_1() As String
    Dim n As Long
    Application.ScreenUpdating = False
    For Each range_1 In Selection
        text_1 = Split(range_1.Value, vbLf)
        For n = 0 To UBound(text_1)
            If Left(text_1(n), 1) <> Chr(149) Then
                text_1(n) = Chr(149) & " " & text_1(n)
            End If
        Next n
        range_1.Value = Join(text_1, vbLf)
    Next range_1
    Application.ScreenUpdating = True
End Sub

Excel VBA Macro for Multiple Bullet Points

  • Then, press the F5 button to run the code.

Bullet point added with all the lines.


Conclusion

In this article, we described 5 methods to add multiple bullet points in a cell in Excel. I hope this will satisfy your needs. Please have a look at our website Exceldemy.com and give your suggestions in the comment box.

Alok

Alok

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo