How to Add Bullet Points in an Excel Cell | Create Bullet List in Excel

In this video I demonstrate how to create bullet lists in Excel. There is no inbuilt functionality for this in Excel but it is still possible.

I demonstrate the following methods for creating bullet points:

1) Shortcut key method
2) CHAR() function method
3) Custom formatting method
4) Cell style method
5) Macro method (with button on Ribbon)

This video will answer the following queries:
How do you add bullet points in Excel?
Can you create a bulleted list in Excel?
How do I make a list in an Excel cell
How do I add bullet points in an Excel cell
------------------------

[seraphiminlove]

This is RIDICULOUS, but it works beautifully. You'd think it would be automatic! Thanks!!

[darksodorian]

Why on earth is excel designed so poorly to a point where inserting a single bullet gets this complex!

[ann]

How do I create different bullet points within a cell? often time I create spreadsheet to plan my travel itinerary, I would like to list the activities by bullet points with in a warped cell . thank you

[lisawhitaker]

Exactly what I needed - and it took 5 minutes. Thank you!

[virenhirpara]

that is very good trick
BUT
it is not working with multiple line in same cell.
can please give some solution for that?

[petermaniche]

This is so helpful... Thanks very much

[baneledludlu]

great work Chester, you're genuis

[IvanCortinas_ES]

Alt+0149 in my regional configuration (Spain). Thank you for this tutorial!

[atharkhan]

Thanks for the about hanging indent (like ms word), while using bullets' in excel?

[freeworld]

hi, please have a video on bin packing in logistics. where you have various boxes in excel and you want to fill them into a bin. which gives an answer in visualization where bin is filled with boxes. hope you got it. thanks. waiting for ur reply

[mototaco]

After entering bullet.... entering long text.... cell height increases due to long text, causing the wrap.... but the alignment of the text on 2nd row lines up with the bullet not the text, is there a way for 2nd row text to line up with text alignment of the row above?

[AngelaORourke]

is there a macro for bullet point list in single cell (using alt+enter)?

[Jason-zrom]

This is ridiculous. You should not have to go through all that for a mere bullet point. Not sure what version you are using but mine does not have the bullet point button and not all keyboards are the same either.

[ParbodhCBali]

How to align multiline text in one cell after a Bullet without moving bullet?. Problem is Bullet also moves as the first letter of text. I want to keep it fixed at a space and rest of multiline text, aligned and move with indent. Bullet should be stationery and text goes indented. Both the Bullet and Text are in same cell.

[threesnice]

can't paste in the bullet into formula???

[KomalImran-uwqx]

my Ctrl+v is not working. when i m trying to paste bullet in custom its not working

[hasnaaalharthi]

How can I remove the bullet points, I want to remove them from all the cells

[rnoqjrm]

I couldn't copy in custom category