Today's trick is from Katie Sullivan on the Word team
There are a few cases where Microsoft Word can do things better than Excel
One of those is adding bullets
Sure - Excel can add a bullet character, using Alt+0149
This would be tedious to manually type this before each line
Or, you can add a custom number format of • @
But for a wide variety of bullets, copy the data to Word, apply the bullet, and then copy back to Excel.
You might use the Excel Reduce Indent button a few times
There are a few cases where Microsoft Word can do things better than Excel
One of those is adding bullets
Sure - Excel can add a bullet character, using Alt+0149
This would be tedious to manually type this before each line
Or, you can add a custom number format of • @
But for a wide variety of bullets, copy the data to Word, apply the bullet, and then copy back to Excel.
You might use the Excel Reduce Indent button a few times
Transcript of the video:
Learn excel from MrExcel podcast, episode 2050 - Bullets in Excel!
I am podcasting this entire book, click that “i” on the top-right hand corner to get to the playlist!
Alright, today's trick is also from Katie Sullivan on the Word team.
There's a few cases where Microsoft Word can do things better than Excel, one of those is adding bullets.
Yeah, sure, Excel can add a bullet character using this awkward set of strokes.
I'm going to hold down Alt and then on the number keypad: 0 1 4 9, BAM, there's a bullet.
How it’s easy to- no, it’s not easy at all, what am I talking about?
And, I don't even know, can I use the numbers at the top, Alt 0?
No, you can't, so bad news, you have to have a numeric keypad, if you have a laptop, then you're stuck using those function keys to get the weird numbers, it's practically impossible.
And, let's just talk about, if you really had to go through and add a bullet to each one of these, Alt 0 1 4 9 Space, and then here, F2 Home Alt 0 1 4 9 Space, it's horrible!
And what Microsoft, with the support team- I'm going to Undo, Microsoft, the Knowledge Base article, and this says “Press Ctrl+1, go into Custom Number Format.
We're going to create a custom number format, where we type Alt 0 1 4 9 Space, and then @ sign.” Which is, the @ sign says the text that we typed, click OK, and yeah, that puts bullets in.
But you know, let's just face it, here's a list, we're going to copy the list, Ctrl+C, we're going to open Microsoft Word, we're going to Paste, select all the things we just pasted.
There are regular bullets, there are check mark bullets, there are little arrowhead bullets, all kinds of good things.
We'll choose one of these, copy everything, Ctrl+C, and then come back to Excel and paste in place, Ctrl+V, alright.
Now, after you do this, you're going to become acquainted with this little symbol here called Decrease Indent to move those back to a normal indent level.
Still a great way to go, thanks to Katie and the entire Word team for this trick.
All of these tips, the Excel tips, and a few Word tips here at the end, are in this book.
Click the “i” in the top-right hand corner to buy that book.
Alt 0 1 4 9!
I am podcasting this entire book, click that “i” on the top-right hand corner to get to the playlist!
Alright, today's trick is also from Katie Sullivan on the Word team.
There's a few cases where Microsoft Word can do things better than Excel, one of those is adding bullets.
Yeah, sure, Excel can add a bullet character using this awkward set of strokes.
I'm going to hold down Alt and then on the number keypad: 0 1 4 9, BAM, there's a bullet.
How it’s easy to- no, it’s not easy at all, what am I talking about?
And, I don't even know, can I use the numbers at the top, Alt 0?
No, you can't, so bad news, you have to have a numeric keypad, if you have a laptop, then you're stuck using those function keys to get the weird numbers, it's practically impossible.
And, let's just talk about, if you really had to go through and add a bullet to each one of these, Alt 0 1 4 9 Space, and then here, F2 Home Alt 0 1 4 9 Space, it's horrible!
And what Microsoft, with the support team- I'm going to Undo, Microsoft, the Knowledge Base article, and this says “Press Ctrl+1, go into Custom Number Format.
We're going to create a custom number format, where we type Alt 0 1 4 9 Space, and then @ sign.” Which is, the @ sign says the text that we typed, click OK, and yeah, that puts bullets in.
But you know, let's just face it, here's a list, we're going to copy the list, Ctrl+C, we're going to open Microsoft Word, we're going to Paste, select all the things we just pasted.
There are regular bullets, there are check mark bullets, there are little arrowhead bullets, all kinds of good things.
We'll choose one of these, copy everything, Ctrl+C, and then come back to Excel and paste in place, Ctrl+V, alright.
Now, after you do this, you're going to become acquainted with this little symbol here called Decrease Indent to move those back to a normal indent level.
Still a great way to go, thanks to Katie and the entire Word team for this trick.
All of these tips, the Excel tips, and a few Word tips here at the end, are in this book.
Click the “i” in the top-right hand corner to buy that book.
Alt 0 1 4 9!
