Forum Discussion
Excel Bullets
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.
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.
Thanks Sergei.
I understand this now. I believe the ability to create a bullet list within a cell would be a very useful addition to Excel. It would simplify a common formatting need that I think many users have.