How to use bullets & numbering within a cell ?

  • Thread starter Thread starter Guest
  • Start date Start date
Not sure what you mean by "numbering", but here's an easy way to insert a
bullet point:

Hold down the [alt] key...type 0149...release the [alt] key
Continue editing

(To save keystrokes....after creating the 1st bullet....copy that cell to
wherever you need another bullet.)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
You could create the list in Word, then copy to Excel. This will put each
line in a separate cell. Then, you would have to combine the cells, whether
by copying or concatenating, and add alt-enter at the end of each line.


Ron Coderre said:
Not sure what you mean by "numbering", but here's an easy way to insert a
bullet point:

Hold down the [alt] key...type 0149...release the [alt] key
Continue editing

(To save keystrokes....after creating the 1st bullet....copy that cell to
wherever you need another bullet.)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


Sunil Verma said:
How can we insert bullet & numbering with in a cell ?
Click to expand...
Click to expand...
 
Bullets can be inserted by using ALT + 0149 from the NumPad

To get more than one line in a cell type your number then hit ALT + ENTER.

Once you experiment you will get the idea.

You can make a bulleted/numbered list in a cell.


Gord Dibben MS Excel MVP


On Tue, 2 May 2006 03:37:01 -0700, Sunil Verma <Sunil
 
I'm not sure what you're saying.
Are you saying that we can put multi-lined text in a single cell (using
alt-enter) and number the lines by typing in the numbers, or adding bullets
manually as you say.
Or Are you saying it's possible to create a list in a single cell, and have
it automatically numbered or bulleted, as in Word. If so, I'd appreciate
more detail, as I haven't been able to find out how to do so.
Thank you
 
Patricia

See answers in-line below

I'm not sure what you're saying.
Are you saying that we can put multi-lined text in a single cell (using
alt-enter) and number the lines by typing in the numbers, or adding bullets
manually as you say.
Click to expand...

The above statement matches my instructions. Must be done manually.
Or Are you saying it's possible to create a list in a single cell, and have
it automatically numbered or bulleted, as in Word. If so, I'd appreciate
more detail, as I haven't been able to find out how to do so.
Thank you
Click to expand...

No automatic bulleting or numbering as in Word.


Gord
Gord Dibben MS Excel MVP
 
Thank you very much. Knowing that something can't be done is helpful, as it
saves time not looking for it :)
 
Back
Top