How To Make A Bullet Point In Excel

Excel is not a discussion processor software, only yous may all the same want to list things in various parts of your workbooks. Bullet points are great for creating lists, as its the universal indicator of an unordered list. Here, we're going to cover iv dissimilar means to insert a bullet point in Excel (•).

Download Workbook

Re-create & Paste

Copy & Paste whatsoever of the characters (filled and hollow versions) from beneath:
•
◦

Enjoy!

Alt Code

You tin can insert a bullet bespeak in Excel using your keyboard but. All you demand to exercise is to agree downwards the Alt button while typing in the respective lawmaking for the character. While holding the Alt key, press 7 to add a bullet point. Use Alt + 9 to place a hollow circumvolve.

Symbols

Excel, just like Word, features a Symbols bill of fare that lists all supported characters in a single place. You can find the Symbol dialog by post-obit the INSERT > Symbols > Symbol path in the Ribbon.

In the Symbol dialog, choose a font and type in whatsoever of the post-obit codes into the Character code box:

2022 for •
25E6 for ◦

Formula

Yous can insert a bullet bespeak using formulas as well! The UNICHAR function of Excel can return a Unicode character based on its specific numeric value. Enter 8226 into the part to create the bullet point. For a white bullet. this code is 9675.

=UNICHAR(8226)

=UNICHAR(9675)

Bonus: Populating bullet points after inbound value

You can utilise number formatting to populate a bullet point in a cell before the string.

Here are the steps to fix your cells to behave like shown above:

Select the cells where you want to populate bullet points
Press the Ctrl + 1 combination to open the Format Cells dialog
Get to the Number tab active if it is not selected
Select Custom from the Category listing
Identify a bullet point and @ character into the Type box (e.g. "• @")
Click OK to save the custom number formatting.

That's all! If you had followed these steps, you defined a custom number format of your ain. An @ graphic symbol is a placeholder for any text value. From now on, if you enter a text into the cell, Excel volition create a bullet point before the text automatically.