Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel 2003 Drop Down Box
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! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel 2003 Drop Down Box
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 DataValidationSettings. In the Allow box select List and in the Source box put $F$1:$F$5 and OK. "Brooklyn" wrote: 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! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel 2003 Drop Down Box
DV dropdown boxes ignore formatting of the list range.
Your symbols will show up as plain text. Gord Dibben MS Excel MVP On Fri, 19 Feb 2010 07:51:02 -0800, Brooklyn wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down Box Values - Excel 2003 | Excel Discussion (Misc queries) | |||
excel 2003 drop-down box color changes how | Excel Worksheet Functions | |||
Excel 2003 - Drop Down List | Excel Worksheet Functions | |||
Drop Down in Excel 2003 | Excel Discussion (Misc queries) | |||
Drop-down lists in Excel 2003 | Excel Discussion (Misc queries) |