How to Insert Bullet Points in Excel (Quick and Practical Solution)

How to Insert Bullet Points in Excel

In this video tutorial, we’ll be having a look at a quick and practical solution to how to insert bullet points in Excel.

Let’s not waste any time and get straight into it!

Would you rather watch this tutorial? Click the play button below!

There are multiple ways how to insert bullet points in Excel and today, we’re gonna go through the easiest, most practical one.

How to Insert Circle Bullet Points in Excel

Let’s say we want to display the list of these three tasks from the table using bullet points in column D. First, we’ve got to select the cells where the list with bullet points will display.

How to Insert Bullet Points in Excel - select the cells

Then, through a right-click, we access the option ‘Format Cells’.

How to Insert Bullet Points in Excel - Format Cells

In the tab ‘Number’, we need to select the category ‘Custom’.

How to Insert Bullet Points in Excel - Number
How to Insert Bullet Points in Excel - Custom

Now, what follows is crucial to getting our bullet points to display with the task list.

To insert bullet points in the cells, start with entering the specific bullet point symbol you want to use here, in this field, and add a space followed by the at sign.

How to Insert Bullet Points in Excel - specific bullet point symbol

Once done, press OK and let’s try it out together!

When we type in ‘Task 1, 2, 3’, Excel inserts the bullet point we entered in the ‘Type:’ field a short while ago in front of each entry.

How to Insert Bullet Points in Excel - Excel inserts the bullet point

To change the type of the bullet point is actually child’s play. Let’s have a look and see.

How to Insert Empty Bullet Points in Excel

Just as we started a while ago, we need to select the cells where we want to make changes.

How to Insert Bullet Points in Excel - select the cells where we want to make changes

Through a right-click we choose ‘Format Cells’ and in the field ‘Type:’ we need to insert the symbol we want to use.

How to Insert Bullet Points in Excel - Format cells

For example, now instead of the circle bullet point, we want to use an empty bullet point, so we’ll enter it here.

How to Insert Bullet Points in Excel -  circle bullet point

Of course you can use any type of bullet point or any symbol you like. So, we’re gonna go for the empty bullet point now. If you need, you can find this combination of bullet points in the list below, so that you could copy and paste it conveniently anytime.

• @
◦ @

Once we’ve inserted the chosen symbols, we press OK and Excel adds these bullet points to the text within the selected cells.

How to Insert Bullet Points in Excel - Excel adds empty bullet points

And even if you change the information in the table, the selected bullet points will keep displaying in the cells formatted this way.

How to Insert Bullet Points in Excel - the selected bullet points will keep displaying

Don’t miss out a great opportunity to learn:

If you found this tutorial helpful, give us a like and watch other tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!

Comments

Add comment

Your email address will not be published.

Your personal information will only be used for the purpose of processing this comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.