Bullet Points in Excel

Updated on December 26, 2023
Article byWallstreetmojo Team
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

How to Add Bullet Points in Excel? (Top 5 Methods)

Bullet points in Excel are symbols used to represent text or numbers in a list format. We can use various keyboard shortcuts to insert bullet points in Excel, such as ALT+7 from the numeric keyboard for a solid bullet point. We can use the “Edit” tab to insert a bullet point in Excel.

Below is the list of the top 5 methods to insert bullet points in Excel.

  1. Using Keyboard Shortcut
  2. Using Symbol Menu
  3. Copying a Bullet List from Word File
  4. Using Excel Formula
  5. Creating Custom Bullet Points

Now let us discuss each of the methods in detail and an example.

Bullet Points in Excel

You are free to use this image on your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Bullet Points in Excel (wallstreetmojo.com)

#1 Inserting Bullet Points using Keyboard Shortcuts

The fastest way to insert a bullet point is by using a keyboard shortcutKeyboard ShortcutAn Excel shortcut is a technique of performing a manual task in a quicker way.read more.

Select the cell where we want to insert the point, then press the “Alt 7 or Alt + 0149” for a solid bullet.

There are many different types of fancy bullets we can insert in Excel.

bullet points in excel example 1.1

To copy the bullet into other cells, we can drag the fill handleFill HandleThe fill handle in Excel allows you to avoid copying and pasting each value into cells and instead use patterns to fill out the information. This tiny cross is a versatile tool in the Excel suite that can be used for data entry, data transformation, and many other applications.read more to copy it to the alongside cells.

bullet points in excel example 1.2

For the cells that are not adjacent, we can copy-paste the bullet point to it by copying the bullet using “Ctrl + C.” Then, press “Ctrl + V” to paste the copied bullet.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

#2 Adding Bullet Point in Excel Cell using Symbol Menu

If you do not have a Numpad or do not remember the key combination, using the symbol menu is the quickest way to insert bullet points.

  1. We must click on the Insert tab, then select the Symbol group at last and click on it.

    bulletpoints in excel example 2.1

  2. A symbol dialog box will appear on the screen.

    bulletpoints in excel example 2.2

  3. We will select the cell where we want to insert the bullet point.

  4. Then, we will select the symbol we would like to use for a bullet point.

    bulletpoints in excel example 2.3

  5. Next, click on the “Insert” button to insert.

    bulletpoints in excel example 2.4

Now, we will insert the symbol in the selected cell.

#3 Copying a Bullet List from Word File

Suppose we have already created a bullet list in Word. Then, we can copy all the lists and paste them into Excel.

  • Step 1: We need to select the bullet list in Word.
bullet points in excel example 3.1
  • Step 2: We will press Ctrl + C to copy it.
bullet points in excel example 3.2
  • Step 3: Select the cell where we want to insert the bullet point in Excel.
  • Step 4: To paste the list, press Ctrl + V. This will paste all the lists along with the bullet points.
bulletpoints in excel example 3.3
bulletpoints in excel example 3.4

#4 Inserting Bullet Points in Excel Cell using Excel Formula

Suppose, at the same time, we want to insert multiple bullet points. We can use the CHAR Function in Excel.

CHAR function will return the specific character based on a set of charters used by the computer.

As we have seen above, code 0149 is used for the round-filled bullet. So, here it goes with the CHAR formula:

  • Step 1: First, we need to select the cells where we want to fill the bullet.
  • Step 2: Then, write the =CHAR function
bulletpoints in excel example 4.1
  • Step 3: Write the number 149, close the round bracket, and press the “Enter” key.
bulletpoints in excel example 4.2

#5 Creating Custom Bullet Points in Excel

Custom number formatCustom Number FormatExcel custom number formatting is nothing but making the data look better or visually appealing. Excel has many inbuilt number formatting. On top of this, we can customize the Excel number formatting by changing the format of the numbers.read more will help you spare the difficulty of repeatedly inserting bullet points and allow you to insert the bullet points automatically.

Let us see how this custom bullet format works:

  • Step 1: We must select the cell where we want to insert the bullet point.
  • Step 2: Choose “Format Cells” from the context menu by clicking the right button on the mouse. Then, press “Ctrl + 1.”
  • Step 3: Select the “Number ” tab and click on custom from the category.
bulletpoints in excel example 5.1
  • Step 4: Under the type text box, write “Bullet point” or “Alt+7” the type text box and type ‘@’ as a text placeholder.
bulletpoints in excel example 5.2
  • Step 5: Then click “OK.” As a result, it will add a bullet point in the cell.

Things to Remember

  • One must use bullet points to display key features of some issues.
  • It can be used when the order of the list is not important.

Recommended Articles

This article is a guide to Bullet Points in Excel Cell. Here, we discuss how to insert bullet points in Excel cells using the top 5 methods, along with examples. You can learn more about Excel functions from the following articles: –

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *