SAM2009
asked on
How to sort items in dropdown list in Excel 2010?
How to sort items in dropdown list in Excel 2010?
Do you mean a data validation dropdown list or something else?
ASKER
yes you know the arrow and when you click on it, it shows the dropdown list? I just want to sort the content.
Again are you talking about a data validation dropdown list? If so then create a Named Range for the source range (for example MyList) with a "refers To" of something like this: =OFFSET(Sheet1!$A$1, 0, 0, COUNTA(Sheet1!$A$1:$A$1001 )). Then in the Data Validation set "Allow" = List and the "Source" = "=MyList".
What part of that does the "sorting", Martin?
ASKER
Martin what you said I know that and already did that to create my dropdown list but as Tel2 said where is the sort part? How can sort the content in the list?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks