MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Bullets in Excel

October 18, 2017 - by Bill Jelen

Bullets in Excel

Bullets in Word are easy. Why aren't they easy in Excel? Today, we look at several ways to add bullets in Excel.


Katie Sullivan is a Project Manager on the Microsoft Word team. For today's tip, a benefit of Word.

While Excel fans sometimes tease that Word and PowerPoint are freeware apps that come on the Excel DVD, there are times when Microsoft Word offers a feature that Excel does not. In those cases, it makes sense to copy your data from Excel, paste to Word, do the command, then copy back to Excel. Here are some examples of techniques that are better handled in Word than in Excel.

Technique 2

Add Bullets

If you want to add bullets to Excel cells, it is far easier in Word than in Excel. Copy the cells to Word and apply a bullet style. Copy from Word and paste back to Excel. You might have to use the Reduce Indent icon a few times.

Watch Video

  • 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 o @
  • 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

Auto-Generated Transcript

  • Learn Excel from MrExcel Podcast Episode
  • 2051 bullets in Excel I am podcasting
  • this entire book click that I on the top
  • right hand corner to get to the playlist
  • right 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 yep sure Excel can add a bullet
  • character using this awkward set of
  • strokes I'm gonna hold down alt and then
  • on the number keypad 0149 bam there's a
  • bullet how he sees it's not a he savella
  • 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 0149 space and then here f2
  • home alt 0149 space it's horrible and
  • what Microsoft with the support team I'm
  • going to undo undo Microsoft the the
  • knowledge base article and this says
  • press ctrl one go into custom number
  • format we're going to create a custom
  • number format where we tight alt 0149
  • space and then at sign which the out
  • sign says the text that we type click
  • okay and yeah that puts bulletin but you
  • know let's just face it here's a list
  • we're going to copy the list control 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 checkmark bullets there are
  • little Arrowhead bullets all kinds of
  • good things will choose one of these
  • copy everything control C and then come
  • back to excel and paste in place control
  • V all right 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
  • werd 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 01 49

Download File

Download the sample file here: Podcast2051.xlsm

Title Photo: Pixabay

Bill Jelen is the author / co-author of
Excel Dynamic Arrays Straight to the Point

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.