Hello All,
I am using Excel 2003. In sheet1 I have a drop box that is using the data validation function to refer to a list that is in Sheet2. The list has 1084 entries and it would really help if I could get the auto complete to work. Also, the scroll wheel on the mouse does not work inside the drop down box. Is there a way to enable both the auto complete and the scroll wheel?
Thanks!
I am using Excel 2003. In sheet1 I have a drop box that is using the data validation function to refer to a list that is in Sheet2. The list has 1084 entries and it would really help if I could get the auto complete to work. Also, the scroll wheel on the mouse does not work inside the drop down box. Is there a way to enable both the auto complete and the scroll wheel?
Thanks!