To insert bullet points in the text box is the quickest way. And now, when you insert a text or any number whether positive or negative, it will add a bullet in front of it. In custom formatting, you have to mention 4 different formats from positive, negative, zero and text. All you have to do is to create a custom format to insert bullet points. But the thing is, you need to choose which method works perfectly for you. And, all these methods can be useful in different situations.Īs I said here we have nearby 8 different ways to add a list with bullet points.
A few days back I have realized that actually, we can use 8 different ways to insert bullet points in Excel. In Excel, there is no default way to insert a bullet point like we have in Microsoft Word.īut here is the good news. I mostly use bullet point lists to capture my day to day work To do lists, Important points. In Excel, most of the time we use serial numbers but when you are working on lists the best way is to use bullet points.
