3 Best Ways to Insert Bullet Points in Microsoft Excel

Bullet points are great when working with Detailed items such as the menu agenda, action points, etc. However, in Microsoft Excel, bullet points are not as easily accessible a feature as they are in Microsoft Word. This is because Microsoft Excel does not have a ribbon button for creating bullet points. Here are 3 of the best ways to insert bullet points in Microsoft Excel.

While there's no direct option for including bullet points, there are other options you can try. Here are some of the best ways to insert bullet points in Microsoft Excel.

How to Add Bullet Points in Excel Using Keyboard Shortcuts

Dotted points have different symbols to represent them. An example of a commonly used symbol for a dot is the center dot “•.” In Microsoft programs like Excel, these symbols have an abbreviation. Here's how to use the keyboard shortcut to create a dot:

Step 1: Click the button "Start" on the taskbar to open the Start menu and type excel to search for the application.

Step 2: From the results, click Apply or Microsoft Excel workbook to open it.

Step 3: In an Excel workbook, select cell which you want to insert a bullet point.

Step 4: On your keyboard, press and hold the following keyboard shortcuts (and key sequences) to get the accompanying bullet point symbols:

Table showing keyboard shortcuts for dot symbols

It's important to note that you'll need a keyboard with a numeric keypad for this shortcut to work. Also, make sure you have the number lock enabled on your keyboard to get the correct result from using this keyboard shortcut.

How to add bullet points in Excel using the CHAR formula

Another way you can add bullet points to your Excel spreadsheet is to use the CHAR formula. You can use the CHAR formula with the American Standard Code for Information Interchange (ASCII) standard to encode each letter, number, and symbol on computers with a corresponding number. By typing the CHAR formula and its corresponding ASCII code, a bullet will appear. Here's how to use it to create your bullet point:

Step 1: Click the button "Start" on the taskbar to open the Start menu and type excel to search for the application.

Step 2: From the results, click Apply or Microsoft Excel workbook to open it.

Step 3: In an Excel workbook, select cell which you want to insert a bullet point.

Step 4: In the cell, enter Symbol = accompanied b CHAR. So you will need to enter =CHAR.

Step 5: Click on Tab key On the keyboard to get the first bracket.

Step 6: Type 0149 Inside the bracket and then press Enter To see the resulting code.

Using a formula to introduce a dot symbol will limit your ability to add text after it.

How to Add Bullet Points in Excel Using the Symbols Menu

In Microsoft Excel, there's a Symbols menu that contains most of the symbols not visible on the keyboard or the Excel ribbon. Here's how to access it to add bullet points to your Excel spreadsheet:

Step 1: Click the button "Start" located on the taskbar to open the menu "Start" And type excel To search for the application.

Step 2: From the results, click an app or workbook. Microsoft Excel to open it.

Step 3: In an Excel workbook, select cell which you want to insert a bullet point.

Step 4: On the Excel ribbon, click the tab Insert.

Step 5: Click on the icon set drop-down menu and select code from the context menu.

Step 6: Click the tab "Symbols" In the Symbols dialog box.

Step 7: Click on the drop-down menu next to the line and select (plain text).

Step 8: Scroll through the icons shown and select Favorite code You have to point.

Step 9: Click Insert To add a bullet point to your spreadsheet. The point will appear in the selected cell.

Fix formulas that don't work in Microsoft Excel

if CHAR format did not work When inserting bullet points in Microsoft Excel, try to verify that you followed the above steps exactly. If it still doesn't work, try checking whether the formula is formatted as text and whether there are circular references within the Excel sheet.