Excel

[Zouz]

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.

Zouz wrote:
>
> 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

[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.)