Forum Discussion

Temporary User0101's avatar
Temporary User0101
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
SergeiBaklan's avatar
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's avatar
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's avatar
    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.

Resources