When you don't get a response to a post consider clarifying it. With
precise "steps to reproduce" ideally. Start with what kind of drop down you
have. There are at least 3 kinds in Excel.

--
Jim
"robert morris" wrote in message
...
|I have Excel 2007 - I have created a drop down list in column "I" the drop
| down boxes are in column C - Although my list (col I) is sorted A - Z my
| drop down box opens with the list showing Z - A. I want it to open with
A -
| Z. What am I missing? I have searched "help" with no results.
|
| Bob M.
|