5 Simple Ways to Add Bullet Points in Excel (Shortcut + VIDEO)

Watch Video – How to Add Bullet Points in Excel

You can easily add bullet points in a cell Excel (Yes.. easily).

Until I knew this trick, I used to put a dash (-) or arrow greater than (>>) at the beginning of the text, and that could sometimes be a pain.

I always wondered why was Excel devoid of such basic functionality.

But that was just my ignorance. There is not one, but many ways to add bullet points in a cell in Excel.

How to Add Bullet Points in Excel

In this tutorial, you’ll learn various ways to insert bullet points in Excel. While all these methods are quite simple, you only need to know a couple to get your work done.

Using Keyboard Shortcut

You can quickly insert bullet points in Excel using the following keyboard shortcuts.

If you have a numeric keypad on your keyboard:

  • Select the cell in which you want to insert the bullet.
  • Either double click on the cell or press F2 – to get into edit mode.
  • Hold the ALT key, press 7 or 9, leave the ALT key.
  • As soon as you leave the ALT key, a bullet would appear.

Bullet points in Excel - Alt 7

ALT + 7 and ALT + 9 both inserts a different kind of bullet (see below):

Bullet points in Excel - Shortcuts

If you do not have a numeric Keyboard (like my laptop), activate the NumLock first and then repeat the above steps (or try with ALT + FUNCTION + 7)

If you want to insert more bullet points in the same cell, in the case of having a list in a single cell, repeat the same steps. For example, if you are building a list in a cell, enter the bullet followed by the item name, press Alt + Enter to insert a line break, and then insert the bullet again (as shown below):

Insert Bullet points in Excel - Multiple Bullets in Same Cell

Note: Once you have the bullet in a cell, you can copy it like any other character.

See Also: 200+ Excel Keyboard Shortcuts.

Using Insert Symbol Dialogue Box

You can use the Insert Symbol option in Excel to insert bullet points in Excel.

Here are the steps:

  • Go to Insert –> Symbols –> Symbol.Add Bullet points in Excel - Symbols
  • In the Symbols dialogue box, within the Symbols tab, select the Font.Add Bullet points in Excel - Select Font
  • Scroll down the symbols list and select the bullet you want to insert.Bullet points in Excel - Select Bullet Symbol
  • Click on the Insert button.Bullet points in Excel - Insert Bullet Symbol

This will insert the bullet in the selected cell. Once you have the bullet in a cell, you can copy-paste it wherever you need it.

Also read: Start New Line in Excel Cell

Using the CHAR Function

You can also use the CHAR function to insert bullet points in Excel.

If you enter =CHAR(149) in Excel, it automatically gets converted into a bullet.

Insert Bullets in Excel - CHAR function

This could be useful when you have a list of items and you want to add a bullet to all the items at one go. Something as shown below:

Bullet points in Excel - Using CHAR function

In the above example, bullet points were added to the list of fruits in A1:A4. Here is the formula used in cell B1:

=CHAR(149)&" "&A1

CHAR(149) inserts the bullet and a space character ensures there is space after the bullet and before the item name.

Insert Bullets in Excel - Using CHAR function

Also read: Insert Arrows in Excel

Using Custom Number Formatting

This one is awesome. You can use custom number formatting to automatically insert bullets in excel as soon as you enter anything in a cell.

Something as shown below:

Insert Bullets in Excel - Custom Number Formatting Demo

Magic. Isn’t it?

Well… Sort of 🙂

What’s working here in the back end is a nifty custom number formatting trick.

Before I get to the trick, here is what you need to know about custom number formatting in Excel. It allows you to specify the format for four kinds of data type:

<Positive numbers> ; <Negative Numbers> ; <Zeroes> ; <Text>

Using custom number formatting, you can specify how each of these data types would be displayed in the cell.

Using this, I can customize cells so that a bullet is automatically displayed as soon as you enter anything in it.

Here are the steps to do it:

  • In any cell, insert a bullet (use the shortcut or insert symbol technique shown above).
  • Double click on the cell that has the bullet (or press F2 to get into the edit mode), select the bullet, and copy it.Insert Bullet in Excel - Copy Bullet
  • Select the cells on which you want to apply the custom number format (so that the bullet points are automatically inserted).Insert Bullet in Excel - Copy Cells custom formattin
  • Press Control + 1. It will open the Format Cells Dialogue box.Insert Bullet in Excel - Format Cells Dialogue Box
  • In the Number Tab, select Custom.Add Bullet points in Excel - Select Custom
  • In the type field, enter:  • General;• General;• General;• GeneralInsert Bullet in Excel - enter format in custom number format field
  • Click OK.

That’s it. Go to the cells and try entering anything. It will automatically show the bullet at the beginning.

Also read: Insert Symbols in Excel

Copy Pasting a list from MS Word or PowerPoint

You can easily copy and paste a list with bullet points from MS Word into Excel.

If you have a bullet point list in Word, you can paste it in either a single cell in Excel, or get each bullet point in a different cell.

(Note: Copied list from Word and PowerPoint behave a bit differently when pasted in Excel).

Copy bullet points in a single cell

  • Copy the bullet points from Word.Insert Bullet in Excel - Copy List Word
  • Double-click on the cell where you want to copy the list.
  • Press Control + V to paste it. Insert Bullets in Excel - Single Cell Copy

This will paste the bullet list in the same cell.

Note: In this case, MS Word and PowerPoint behaves differently. While the bullet list from word gets pasted as is (as shown above), the one from PowerPoint gets pasted without the bullet points.

Copy bullet points in different cells

  • Copy the bullet points from Word or PowerPoint.
  • Select the cell where you want to copy the list.
  • Press Control + V to paste it. Insert Bullets in Excel - paste on different cells

These are the five simple ways you can use to add bullet points in Excel. Every method has its own benefits and can be used accordingly.

Hope you have enjoyed this article. Let me know your thoughts by leaving a comment below.

You May Also Like the Following Excel Tutorials:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

8 thoughts on “5 Simple Ways to Add Bullet Points in Excel (Shortcut + VIDEO)”

  1. #4 Custom Number Formatting allows the Numbers or Text to still be used as such. “● 1” & “● 2” in two cells added together will result in “● 3”. All other methods will result in an error.

    “● A” & “● B” concatenated will result in “● AB”, instead of “● A● B” with the other methods.
    However, if you have different symbols in the formatting and concatenate or add, the formatting of the result can be unpredictable.

    Reply
    • Thanks for commenting Jim.. These methods are not interchangeable but can be used based on the situation. As you mentioned, Custom Number format just changes the way data is displayed in the cell, but the data/values remain the same.

      Reply

Leave a Comment

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster