5 Ways to Add Bullet Points in Excel

In this video, you'll learn five ways to insert bullet points in Excel.
This could be useful when you have to create a bulleted list in a cell. If your report is to be printed, it also makes your text look more readable.
You can quickly add 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.
In this video, I also cover the following ways to insert bullet points in Excel:
-- Using Insert Symbol Dialogue Box.
-- Using CHAR Function.
--Using Custom Number Formatting.
-- Copy Pasting a list from MS Word or PowerPoint.
Using CHAR function is great when you already have text and you quickly want to add bullet points to it.
Read More: trumpexcel.com/bullet-points/
Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: ua-cam.com/users/trumpexc...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial

[@mavrshakaryan]

Great video! Thanks. I really like the custom number formatting.

[@thehonestguyreviews4516]

thank you very damn much, a lot of videos out there but I found this very easy and fast to the point.

[@calebmarcum3738]

Thank you. This was very very helpful. I like the many options you gave.

[@jaidevtantry2464]

Wonderfully explained. Kudos to the presenter.

[@saaneroa5024]

Fantastic tutorial. Thanks for sharing.

[@kanyewest132]

Thanks bro. Very helpful!

[@FlorinBaci]

You just saved the day, Gracias!

[@TheNmg101]

Thanks so much, it helped a lot!

[@leahkane5774]

Thank you! Excellent and clear video.

[@KadvaKorp]

Well explained and helpful. Thank you.

[@preetiwad]

This was really helpfull, I have additional question, is there a way to created nested bulleted list in Excel like we can do in power point or word doc?

[@joshuacaleb7197]

i swear this is the best of the best. it has really helped me

[@Wildguy6664]

I've been watching videos about this topic forever and you are the best, shokrً

[@nexuslux]

Thanks, this is helpful!

[@mdgulzaralam2002]

Thank you so much
very helpful it.

[@marisaramos7173]

Very helpful. Thanks

[@radouaneguerchal9912]

Thanks , good trick ,I encourage you.
it'll be very generous if you make some videos about dashboards with power query and power pivot.

[@sherifrafla9426]

Excellent thanks.

[@kzzink649]

Lots of options to do this. Thank you.

[@zainulabdeen5982]

Thanks alot it was really helpful

[@lowjames931]

useful👍🏻

[@diyworld6995]

Super Tutor

[@timlong8098]

Brilliant explanation

[@saharshtripathi5277]

Thankx 4 d video

[@baswanikumar5889]

That's very nice...

[@verzueim]

that's nice, but can you expand in what is the best practice to add a bullet point into a simple text (Notepad for as e.g.). Is there a way we can easily assign a specific short cut from the keyboard? Thank you in advance!👌

[@binaykumarnayak9114]

Thank you so much Sir...

[@tasadduqmajeed68]

Thank you so much.

[@chiragarora9453]

It would be helpful, if could tell us, how to create bulleted list using custom numbers, when you have multiple values in a single cell for eg orange, apple , etc in the same cell

[@anuragpareek6121]

Thanks a lot ☺️

[@marlinejuste]

very useful!

[@deepayadav4583]

I like it thanks

[@sowmyamanjunath526]

super sir its very much useful.

[@ronaldbalbuena7283]

wonderful

[@a.r27]

Thanks

[@gmm5630]

hero!

[@mayankpalsingh6502]

Nice

[@maheshkumarkakumaani9455]

I tried Alt +7 and Alt+9... it ididn't worked.. plz help

[@xcyuan7567]

Try Alt+0149 on numeric key board

[@Blushygirl103]

tq

[@azharbaloch9512]

how can i make numerical bullets

[@thecavemanbeard7062]

Hi, I cant get the • General; • General; • General; • General; to work it says
" Microsoft excel cannot use the number format you typed
try using one of the built in number formates"

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

[@deepayadav4583]

Sir custom option Se ni banta

[@Skorrigan]

Unfortunately it's hard to call it bulleting. It should be called "adding a symbol before the first letter in a cell". If you reach the end of the cell and the text is written in the next line, the text will be written directly under the bullet, i.e. it will align to the left edge of the cell and not the the start of the text in the first line. That's not the point of bulleting.

[@Jonesldschn]

So Mine has all the data? ;-D

[@salmanshoukat5738]

how to insert bullets point in one cell in ms office

[@anniengo5591]

Don't know why I clicked Alt + 7 or 9 and it didn't work for me.

[@atharkhan9235]

Thanks a lot Sir for the tutorial........ do you have a trick to manage bullets with paragraph hanging indent in excel? i mean same as MS Word?
Also is that possible that bullet will be added systematically for each line brake (alt enter) in same cell?
For example, following your trick, I typed following 3 lines in a cell but got the bullet with first line only.
• Inshaa Allah, IK will be the next PM of Pakistan
Inshaa Allah, IK will be the next PM of Pakistan
Inshaa Allah, IK will be the next PM of Pakistan

[@gayatridas5243]

It's not working

[@TheMattJames]

bro non of these steps work on mac.

[@glennedwards6946]

Incomplete instruction for laptop keyboards

[@jlopez5402]

Why never an American giving instructions?