How can put numering or pullets in one cell in excel sheet

I'm guessing you want to have a bullet list of items contained in only one
cell that implements word wrap....

Something like this..all in cell A1:
€¢Item one
€¢Item two
€¢Item three

If that's correct, try something like this:
1_Select the cell
2_Hold down [Alt]...type 0149...Release [Alt]
(that puts the bullet point "€¢" in the cell)
3_Type the first list item
4_Hold down [Alt] and Press [Enter]
(That will start a new line in the same cell)
5_Repeat steps 2, 3, and 4 for each list item
6_When done Press [Enter]

If the text does not wrap in the cell
<format<cell<alignment tab....Check: Wrap Text...Click [OK]
Adjust the column width

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"jeyaram" wrote:

How can put numering or pullets in one cell in excel sheet

Alt + 0149(on the numpad)will enter a bullet.

Note: Alt + Enter will give you a line feed in the cell.

i.e. Alt + 0149 type some text then Alt + Enter. Alt + 0149 then more text.

For numbering...........enter 1. <space text then Alt + Enter then 2. etc.

Format the cell to wrap text and autofit the row.


Gord Dibben MS Excel MVP

On Sat, 30 Jun 2007 14:30:00 -0700, jeyaram
wrote:

How can put numering or pullets in one cell in excel sheet