Forum Discussion

Copper Contributor

Sep 01, 2017

Excel Bullets

Previously in Office 365, we could highlight a group of listings and then type into "Tell me what you want to do" the word "Bullets" and they would appear and you could also call them up so you could...

excel

office 365

Wyn Hopkins

MVP

Sep 01, 2017

While this works in Word I didn't think it was ever possible in Excel?

For adding bullets you can use Insert > Symbol > Arial (subset = Geometric Shapes)

To speed this up I copy a bullet point and go to File > Options > Proofing > Autocorrect and paste in the "Replace With" box. Then in the replace box I type ,, (2 commas)

Then whenever I need a bullet I just type ,, and a bullet point magically appears :)

ROB BENJAMIN

Copper Contributor

Mar 02, 2018

The inability to create a bullet list in an Excel cell without going through ridiculous workarounds makes no sense. Especially when Bullets and Numbering are features listed in All Commands.

WHY has Microsoft not made this feature functional?

SergeiBaklan
Diamond Contributor
Mar 02, 2018
Hi Rob,

Another way:

select your list and Ctrl+1

In custom format enter Alt+7 space @ (Alt+7 inserts bullet at any place you apply it)

Result:
- ROB BENJAMIN
  Copper Contributor
  Mar 02, 2018
  Thanks for the helpful reply. This is useful. I also want to be able to create a bullet list within an individual cell as well as in a column of cells. I can do this by copying a bullet list into a cell from a Word document, but that is a very kludgy workaround.
  - SergeiBaklan
    Diamond Contributor
    Mar 02, 2018
    Rob,
    
    In Excel there is no way to apply bullets to existing in cell text clicking on some button or so. If only with macro or third-party tool.
    
    You may only add bullets one by one.
    
    If you enter the text into the cell from scratch you may use Alt+7 to insert the bullet in your text and Alt+Enter to start new line.