Hello
i m new user to excel can someone help me
how can i enter 20 vender name in one cell & it despley only one but when i
go to same cell it despley all & i can choose one of them

Thank You

I believe there is a conflict between what you are asking to do and what can
be done (what version of Office are you using?)

If you want to display all vendors in one cell, select that cell, go to
FORMAT, then CELLS, and on the ALIGNTMENT tab, check "Wrap Text".

If you enter all the vendors in one cell, you cannot individually select one
of them for use elsewhere in the program.

Does this help??? If you let me know what version Excel you are using and
can provide a little more information, I may be able to help more.

Thanks!



"utpal" wrote:

Hello
i m new user to excel can someone help me
how can i enter 20 vender name in one cell & it despley only one but when i
go to same cell it despley all & i can choose one of them

Thank You

hi there thank you but i dont get it

i m using ms office xp i guess ms office 2000

i want all vendor name in one cell then i can choose one of them as i pay

thank you


"1S2RSK" wrote:

I believe there is a conflict between what you are asking to do and what can
be done (what version of Office are you using?)

If you want to display all vendors in one cell, select that cell, go to
FORMAT, then CELLS, and on the ALIGNTMENT tab, check "Wrap Text".

If you enter all the vendors in one cell, you cannot individually select one
of them for use elsewhere in the program.

Does this help??? If you let me know what version Excel you are using and
can provide a little more information, I may be able to help more.

Thanks!



"utpal" wrote:

Hello
i m new user to excel can someone help me
how can i enter 20 vender name in one cell & it despley only one but when i
go to same cell it despley all & i can choose one of them

Thank You

Does this do what you want? Somewhere out of view, type your 20 vendors
names in a column (one name per row)... you can hide the column if you think
your users might scroll over to the area you put them. So, let's say you put
them in Column Z so that the first vendor's name is in Z1, the second
vendor's name is in Z2, and so on down the column until the last vendor's
name is placed in Z20. Now, select the entire column you want this list to
be selectable from (assuming you will want to use it in every cell in the
column; if not, select only the cell or cells you will want this feature in)
and click Data/Validation from Excel's menu bar. On the dialog box that
appears, click the Settings tab and select List from the Allow drop down and
put =Z1:Z20 (don't forget the equal sign) in the Source field. You can also
offer the user some feedback by filling in the appropriate information on
the other two tabs. When ready, click the OK button. Now, whenever your
users click into a cell that you had selected to apply this validation to,
the list you typed in Z1:Z20 will be offered to them for selection (or they
can type a name from the list manually if they wish).

Rick


"utpal" wrote in message
...
Hello
i m new user to excel can someone help me
how can i enter 20 vender name in one cell & it despley only one but when
i
go to same cell it despley all & i can choose one of them

Thank You

Watch this 5 minute video:

http://youtube.com/watch?v=t2OsWJijrOM

--
Biff
Microsoft Excel MVP


"utpal" wrote in message
...
Hello
i m new user to excel can someone help me
how can i enter 20 vender name in one cell & it despley only one but when
i
go to same cell it despley all & i can choose one of them

Thank You