Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
Capturing data in a right way is really important.
In Excel, most of the time we use serial numbers to in data tables but when you are working on lists the best way is to use bullet points.
I mostly use bulleted lists to capture my day to day work (To do lists, Important points).
Now, the bad news is.
In Excel, there is no default way to insert a bullet point like we have in Microsoft Word.
But, here is the good news.
A few days back I have realized that actually, we can use 8 different ways to insert bullet points in Excel.
And, all these methods can be useful in different situations. So, today in this post, I’d like to share with you all those methods.
I bet you have used this method before.
Here are some symbols which you can use as a bullet point.
Shortcut keys are the best way to insert a bullet point if you don’t have the time to play with symbol dialog box.
We have two different shortcut keys and you can use any of these.
Both shortcuts keys will give you a different type of bullets.
If you want to add a dark dot for bullet point you can use Alt + 7 or if you want to add a circle, you can use alt + 9.
You can also use CHAR(149) to add a bullet in a cell. This is a helpful method if you want to insert a bullet in all the cells using a formula.
It’s a one-time setup. All you have to do is to create a custom format to insert bullet points.
Just follow these simple steps.
● General;● General;● General;● General
Let me give you a short note to use custom formatting for bullet points.
In custom formatting, you have to mention 4 different formats from positive, negative, zero and text.
I have used a black dot for all these four types.
And now, when you insert a text or any number whether positive or negative, it will add a bullet in front of it.
To insert bullet points in the text box is the quickest way. You don’t have to run here and there from bullets.
Follow these simple steps.
You can also use the numbers in a text box by using the same method.
Both of the font styles will show an icon instead of alphabet or number. If you enter any number or alphabet you will get a cool icon instead.
You’ll even get a different symbol for a capital letter and lower letter.
To insert a simple black dot use small “l” & small “n” in Webdings & Wingdings respectively.
You can also use bullet point in cell comment using symbols.
Smart art is also an effective way to create an organized list of bullet points.
Bulleted lists are handy when you want to create lists and now you now eight different ways to insert bullet points in Excel.
If you ask me custom formatting is my favorite way for this as it’s a one-time set-up.
Which one is your favorite? Please share your answer with me in the comment section, I’d love to hear from you.
And, please don't forget to share this tip with your friends.