Forum Discussion
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...
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 :)
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 :)
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?
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:
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.
