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