making drop box in excel sheet

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

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


"foxie foxster" wrote:

> 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
>
>
>