I was trading Excel tips with Robert from Florida and he gave me a list of four hard ways to get bullets into Excel. There is now a fifth way and it is super-easy! At least, it is easy if you are using Excel on a Windows machine and you have a numeric keypad on your keyboard.
Transcript of the video:
Learn Excel for MrExcel Podcast Episode 2281.
Bullets: The easiest way in Excel.
Hey, welcome back to MrExcel Netcast. I'm Bill Jelen.
Well I've covered this before on the podcast and there's lots of different ways to do this.
I was reminded I met up with Robert B from Palm Harbor, FL when I was doing a seminar over in Clearwater Beach.
He gave me some great tips including all these ways to do bullets. None of these are the fast way to do bullets anymore.
I've used all of these in the past.
Come out to Insert, Symbols, choose the symbol font. Find the bullet, click Insert.
Or this horrible formula right here.
=CHAR(149)&" "&B2 right. I mean that all works. But just forget it.
We're not going to use them. A simple let's just type something else.
But if you're going to use a hyphen, going to think it's a formula and they're going to give you a name error.
So you have to type apostrophe hyphen. Alright, forget all this.
All this goes away.
Here's the fast, easy way to do this, at least if you have a number keypad on your computer, right?
So I was surprised I was in Excel help the other day trying to figure out what the character 149 was, and it doesn't. It's not this heart, right?
If you have the number keypad over here that Number 7: Alt and Seven, so right here, just I'm going to hold down alt on my keyboard press 7 on the number keyboard and it types of bullet like that and we're good to go, right?
We have a whole bunch of text cells we want to add bullets to all of them. Check this out.
We are going to go to Ctrl one or Home and the dialogue launcher.
That's going to get us into the number format.
Come over here to format cells, click on custom and what we're going to do is.
Type Alt 7 on the numeric keypad space and then an @ sign.
The @ sign says show me whatever is in the cell.
Alright, so we're going to proceed.
Whatever is in a cell with a bullet, space, and the at sign click OK. How amazing and fast is that? Great.
Hey, if you like this tip or any of my tips please, down there in the YouTube below the video, click subscribe and then ring that Bell.
Post any questions or comments in the comments below.
My new book is out MrExcel XL the Holy Grail of Excel Tips.
Click that "i" in the top right hand corner. Well I want to thank you for stopping by.
We will see you next time for another netcast for MrExcel.
Bullets: The easiest way in Excel.
Hey, welcome back to MrExcel Netcast. I'm Bill Jelen.
Well I've covered this before on the podcast and there's lots of different ways to do this.
I was reminded I met up with Robert B from Palm Harbor, FL when I was doing a seminar over in Clearwater Beach.
He gave me some great tips including all these ways to do bullets. None of these are the fast way to do bullets anymore.
I've used all of these in the past.
Come out to Insert, Symbols, choose the symbol font. Find the bullet, click Insert.
Or this horrible formula right here.
=CHAR(149)&" "&B2 right. I mean that all works. But just forget it.
We're not going to use them. A simple let's just type something else.
But if you're going to use a hyphen, going to think it's a formula and they're going to give you a name error.
So you have to type apostrophe hyphen. Alright, forget all this.
All this goes away.
Here's the fast, easy way to do this, at least if you have a number keypad on your computer, right?
So I was surprised I was in Excel help the other day trying to figure out what the character 149 was, and it doesn't. It's not this heart, right?
If you have the number keypad over here that Number 7: Alt and Seven, so right here, just I'm going to hold down alt on my keyboard press 7 on the number keyboard and it types of bullet like that and we're good to go, right?
We have a whole bunch of text cells we want to add bullets to all of them. Check this out.
We are going to go to Ctrl one or Home and the dialogue launcher.
That's going to get us into the number format.
Come over here to format cells, click on custom and what we're going to do is.
Type Alt 7 on the numeric keypad space and then an @ sign.
The @ sign says show me whatever is in the cell.
Alright, so we're going to proceed.
Whatever is in a cell with a bullet, space, and the at sign click OK. How amazing and fast is that? Great.
Hey, if you like this tip or any of my tips please, down there in the YouTube below the video, click subscribe and then ring that Bell.
Post any questions or comments in the comments below.
My new book is out MrExcel XL the Holy Grail of Excel Tips.
Click that "i" in the top right hand corner. Well I want to thank you for stopping by.
We will see you next time for another netcast for MrExcel.
