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!!

[@ann4621]

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

[@virenhirpara1876]

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

[@darksodorian]

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

[@lisawhitaker7647]

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

[@ChesterTugwell]

Glad it helped!

[@IvanCortinas_ES]

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

[@petermaniche1009]

This is so helpful... Thanks very much

[@naveedyousaf1657]

Excellent!

[@luceroromero3707]

PERFECT- THANKS

[@cristianomasciulli6472]

Love it!!

[@baneledludlu7983]

great work Chester, you're genuis

[@ChesterTugwell]

Thanks! 😃

[@fpmachado]

Excellent! Thank You very much!

[@ChesterTugwell]

Glad it was helpful!

[@johnalidu6328]

Good job.

[@atharkhan9235]

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

[@freeworld4988]

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

[@TheTruth4them]

Thank you!!!

[@pharmacy4984]

Tq so much

[@mototaco2132]

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)?

[@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.

[@ahmedhussein1880]

thanks Bro

[@Jason-zr6om]

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.

[@johnalidu6328]

Why don't you try the short cut =CHAR(149) ? As long as you have numbers 0-9 showing on your keyboard.

[@threesnice]

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

[@KomalImran-uw8qx]

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

[@user-rn4oq9jr7m]

I couldn't copy in custom category

[@hasnaaalharthi4223]

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

[@ubaidillahmuhammad20]

I give thumb.....

[@besslau3570]

So complicated 😂