ExcelBanter - Drop down list

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Drop down list (https://www.excelbanter.com/excel-discussion-misc-queries/166028-drop-down-list.html)

robert morris

Drop down list

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.

All times are GMT +1. The time now is 02:20 AM.