making drop box in excel sheet

F

foxie foxster

hi there
i have the following situation:
i have a sheet with some cells
cell 1 cel 2 cel 3
x y function
......
......
in the cell 1 i have to put in some information, same in cell 2 (so x en y
become information)

now i have to put in always the same information eg CN, KD, CV or MM

now i do it manually, but i have seen that i can put a dropbox in with the
values CN,KD,CV, MM
so i have to choose only in the drop box

now i tried to realise that....can't find it....must be with creating an
array or so....but i'm not able to do it

can anyone day how i can realise it.....would be thankfull....my knodlegde
is too small

thx
 
R

Ron Coderre

Try this:

Select the cell

From Excel's main menu:
Data>Validation
Allow: List
Source: CN,KD,CV,MM
Click the [OK] button

OR

Put your list in a column of cells (I'll use A1:A4)
Source: =A1:A4

Does that help?

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

XL2002, WinXP-Pro
 
Top