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 choose what bullets you wanted to use, that is some type of symbol, or numbers and others.
I just tried to use it and once again find it has been removed.
This is something I know a lot of people use and we need to have it easier to use that what Excel is providing to use presently, unless that is, something is wrong with my version of Excel I am currently using and it is really is available but I am being blocked for some unknown reason.
9 Replies
Hello everyone
This is my very first contribution to this amazing Excel community
The easiest way for me to create bullets on the fly in Excel, if you have a numeric key pad is:
ALT + 7 you get a solid bulletALT + 9 you get a hollow bullet
both of them can be formatted, resized, recolored as regular text using options on the Font group of the Home Tab.Hope this helps
Nabil Mourad- 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 :)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:
