Drop Down Sorting

[Varne]

Hi

Is it possible to make items to apear in alphabetical order in a Drop Down
without doing the list in alphabetical order? Could someone help?

Thanks.

M Varnendra

 

[Bob I]

From Help

Note You may want to sort the data in the order that you want it to
appear in the drop-down list.

 

[Varne]

Hi Bob

I do not get that. Could you please elaborate? Or I elaborate it first!

There is a drop down in my Excel sheet. It drops down a list when clicked.
The source list is not sorted. Therefore when clicked the drop down drops an
unsorted list. I want the dropped list in a sorted order but I do not want to
sort the source list.

Thanks

M Varne

 

[Bob I]

Pretty simple, the dropdown displays in the order of the selected cells.
If you don't want the Source sorted but you DO want the List sorted then
you will need to have the list point to a range that IS sorted. Copy
your UNsorted source to another range, sort it and point your List at that.