Excel

[Guest]

I am trying to insert bullet points in one cell, but Ii could not find that
option, does it exist? Can i insert bullet points in one cell?

Kindly assist

 

[Dave Peterson]

Not like you can do in MSWord.

You could insert a character, then format it (change the font) to show the
bullet you like.

But that's a manual effort for each bullet.

 

[arkey44]

I use a bullet designed from auto shape in a macro. Very easy and it
will go any where you wish.

 

[Jay]

I am trying to insert bullet points in one cell, but I could not find

that option, does it exist? Can I insert bullet points in one cell?

If you have an "equal sign" character (=) and put it in the "Webdings"
font, you get a "bullet" character.

For example, I put this in A1:
'= abc
(The apostrophe is to make Excel treat it like text, not a formula.)

Then, with A1 selected, I hit the F2 key. This lets me apply formatting to
parts of the text in a cell.

Then I selected the "equal sign" and used the font pull-down to choose
"Webdings."

This gave me a bulleted line with "abc" as the text.

(I have Excel 97.)