Excel 2003 Drop Down Box

[Brooklyn]

I am attempting to create a drop down box in Excel, I have created a list in
a separate range but when I copy that range, it isn't the same in the Drop
Down box. Sounds like a formatting issue, but I can't seem to get the
correct symbols in my drop down box. help!

 

[PJ]

To create a drop-down box you can use the Data-Validation facility. With
your range in,say, F1:F5, select the cell for the drop-down list and go to
Data>Validation>Settings. In the Allow box select List and in the Source box
put $F$1:$F$5 and OK.

 

[Gord Dibben]

DV dropdown boxes ignore formatting of the list range.

Your symbols will show up as plain text.


Gord Dibben MS Excel MVP