Drop Down Box

[themax16]

Does anyone know how i can provide a drop down box for cell population rather then manually trypin the information into each cell?
Thanks
James

[dominicb]

Good afternoon themax16

Why not use the Data > Validation function, in the Allow box select List, and then type your list of possible values into the Source box, or highlight a range of cells containing allowed values.

HTH

DominicB

[themax16]

Thanks very much for your help.

[themax16]

Do you know if this process will exclude the cells from an autofilter?
I have a colum of drop down menus that i wanted to auto filter. this does not seem to be working..
Can You help??
James

[dominicb]

Hi James

Seems to be working OK for me using XL2000. Try again. If you are still struggling post back and I'll upload an example. I know it may be stating the obvious, but there isn't a blank row between your heading and the first row of your data is there...?

HTH

DominicB

[Ron de Bruin]

Look on Debra's site for Data Validation
http://www.contextures.com/xlDataVal01.html


--
Regards Ron de Bruin
http://www.rondebruin.nl


"themax16" <[email protected]> wrote in message
news:[email protected]...
>
> Does anyone know how i can provide a drop down box for cell population
> rather then manually trypin the information into each cell?
> Thanks
> James
>
>
> --
> themax16
> ------------------------------------------------------------------------
> themax16's Profile: http://www.excelforum.com/member.php...o&userid=23622
> View this thread: http://www.excelforum.com/showthread...hreadid=389018
>

[themax16]

It seems that sometimes the simple answer is the correct one.... i did have a line spacing it.
Many thanks

[Jay]

DominicB,

Do you know if it is possible to change any characteristics of a drop down
list created using data validation, eg width of list, or font size? I am
using text aligned at 90°, so not much width for drop down list...
--
Regards,
Jay


"dominicb" wrote:

>
> Good afternoon themax16
>
> Why not use the Data > Validation function, in the Allow box select
> List, and then type your list of possible values into the Source box,
> or highlight a range of cells containing allowed values.
>
> HTH
>
> DominicB
>
>
> --
> dominicb
> ------------------------------------------------------------------------
> dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
> View this thread: http://www.excelforum.com/showthread...hreadid=389018
>
>