This article was last updated by on

How to Add Bullet Points in Excel? [5 Easy Methods]

Have you ever wondered how to insert bullet points in Microsoft Excel?

Unlike MS Word, MS Excel does not have built-in buttons for adding bullet points.

However, it does not mean you can not insert bullet points in Excel. Well, you can insert bullets into a single cell or multiple cells.

You can add bullet points in Excel using keyboard shortcuts, the insert tabs option, custom formatting, and copy and paste from Word to an Excel sheet.

This article will show a few easy methods to add bullet points in MS Excel.

So, let’s go over all the methods without any further ado.

How to Add Bullet Points in Excel? [5 Easy Methods]

Effective use of bullet points can help highlight the important content by drawing the viewer’s attention and improving readability and efficient communication.

Here are five easy methods to add bullet points in MS Excel;

1. With a Keyboard Shortcut

Using Keyboard shortcuts is one of the easiest methods to insert bullets in MS Excel.

Follow these steps to insert bullets:

  1. First, select the cell where you want to insert the bullet points.
  2. Then, hold the Alt+7 or Alt+0149.
  3. Alternatively, hold Alt+9 to insert an empty hollow bullet(○).
  4. Once you leave the Alt key, a bullet(•) appears in the cell.
  5. You can use Alt+1 to Alt+1049 to insert different solid shapes.
  6. alt key for adding solid shapes excel

  7. Once the symbol is inserted, you can drag the Fill handle to copy it to other adjacent cells.
  8. drag filling button excel

  9. After using the filling handle tool in MS Excel, you can see the final result.
  10. final result after filling handel excel

  11. If you want to repeat bullets in non-adjacent cells, you can simply copy them and paste them to the cells where you want bullets.

Similarly, you can also add multiple bullet points to the same cells. Follow the steps below to add multiple bullet points;

  1. First, insert the first bullet following the above steps.
  2. Break the line with the Alt+Enter keys.
  3. Then, repeat the process to insert the second bullet.
  4. for multiple bullets in a single cell excel

Note: If you do not have a numeric keypad, you can turn it on with Shift + Num Lock or Fn+ Num Lock or insert bullets using the insert option.

2. Using Insert Tab

Follow these steps to insert bullets with the insert tab from the main menu;

  1. Click Insert > Symbol drop-down icon > Symbol.
  2. go insert symbol drop down excel

  3. A dialog box will appear; search for the bullet point you want. Click the drop-down icon and search for the bullet.
  4. Alternatively, you can use the default bullet. Select the fonts as Normal text and character code as 2022, and Unicode as hex.
  5. Finally, click the Insert button. Once you add the bullets, you can copy and paste them into other cells.
  6. set font as normal text character code 2022 insert excel

Read more to learn how to remove leading zeros in Excel.

3. Using CHAR Formula

You can use the CHAR Excel formula to insert bullets and customize your sheet with different formula shortcuts.

Simply enter the =CHAR(149) formula to insert a bullet if you have a shorter list of items.

Alternatively, if you already have an existing extensive list and want to insert the bullets, you can use the formula  =CHAR(149)&” “&(cell_reference).

Here, call_reference represents the cell where you want to insert bullets.

Follow the steps below to add bullets using the CHAR formula;

  1. First, select the cell where you want to add bullets.
  2. Use the formula in the formula bar and hit the Enter button.
  3. insert formula excel

  4. You can drag the fill handler icon to add bullets in the adjacent cells. Below is the final result.
  5. drag icon final result after adding formula excel

Note: You can change the bullets to other solid symbols. You can change the Char number to whatever you want.

4. Copy and Paste from Word

If you find the previous steps time-consuming, copy the bullets from your word document and paste them into your Excel sheet.

Follow these steps to copy and paste from Word.

  1. Copy (Ctrl+C) the list of items with the bullet points from your Word document.
  2. copy the list from word document

  3. Then, paste (Ctrl+V) it into the Excel sheet.
  4. Here, you will see the whole list of items with the bullets.
  5. paste the list to excel

To add all the bullet points in one cell, double-click it and press Ctrl+V.

5. Create the Custom Format

If you are working with a large list of items and want to add the bullets, it is better to use the Custom format.

Follow these steps to insert the bullets by creating the custom format.

  1. First, select a group of cells where you want to add the bullets and right-click on it.
  2. Select the Format cells option from the list.
  3. select the cells format cells excel

  4. A dialog box appears; select Number from the horizontal menu panel.
  5. Click the Custom option under the category and enter •@ in the search bar. (You can create and copy the bullet first with the keyboard shortcuts Alt+7 and Ctrl+C, respectively)
  6. Finally, click the Ok button. You can drag the fill handler icon to add bullets in the adjacent cells.
  7. select number custom .@ ok excel

The Bottom Line

I used to start every text item with a dash (-) or an arrow until I learned the trick for inserting bullets in my Excel sheet. The procedure could be tedious at times.

You can now insert bullets in multiple cells with the CHAR function.

With these super helpful techniques, you can make dull spreadsheets look professional.

Continue reading to learn how to fix Excel drop-down list not working.
0 Shares:
Leave a Reply

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

You May Also Like