Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
I use a bullet designed from auto shape in a macro. Very easy and it
will go any where you wish.
 
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?
Click to expand...

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.)
 
Back
Top