If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|