Start Excel 2016 In Spreadsheet Serial Numbers But

And now, when you insert a text or any number whether positive or negative, it will add a bullet in front of it.

Start Excel 2016 In Spreadsheet Serial Numbers But

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.

I mostly use bullet point lists to capture my day to day work (To do lists, Important points).

In Excel, there is no default way to insert a bullet point like we have in Microsoft Word.

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, Id like to share with you all those methods.

But the thing is, you need to choose which method works perfectly for you.

Add a Bullet Point from Symbol Dialog Box 2.

Add a Bullet Point from Symbol Dialog Box I bet you have used this method before.

Select the cell in which you want to add a bullet point Go to Insert Tab Click on Symbol.

Once you click on the symbol button, youll get a symbol dialog box.

In symbol dialog box, you have a lot of smart symbols to use as a bullet point or you can simply use a black dot.

Here are some symbols which you can use for a list in Excel as a bullet point.

Insert Bullet Points with a Shortcut Key Shortcut keys are the best way to insert a bullet point if you dont 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.

Use CHAR Function for Bullet Points 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.

Enter CHAR(149) A1 Now, drag the formula up to the cell in which you want to add the bullet.

Apply Custom Formatting for Bullet Points Its a one-time setup.

All you have to do is to create a custom format to insert bullet points.

General; General; General; General In type input bar, enter the following formatting.

How it works 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.

Start Excel For Mac 2016 In Spreadsheet