Drop Down Box

T

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
 
D

dominicb

Good afternoon themax16

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

HTH

Dominic
 
T

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. thi
does not seem to be working..
Can You help??
Jame
 
D

dominicb

Hi James

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

HTH

Dominic
 
T

themax16

It seems that sometimes the simple answer is the correct one.... i di
have a line spacing it.
Many thank
 
J

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