Using Excel 2016 on a Mac, I have a drop down list as a Data Validation that no longer works. The small arrow on the bottom right is there, but if I click on it, the selected cell just moves to the right instead of opening the drop down list. My passport for mac whats the difference between. There is a column to the left of this whereby the drop down list usually works, but sometimes the drop down list appears about an inch to the right of that cell, strangely enough. I reinstalled Excel on this machine but there is no improvement. I checked all the preferences to see if I could see if anything was amiss, and I check the data validation settings.
Jan 24, 2017 - You can add drop-down lists to cells in Excel containing options such. If you decide you want to remove the drop-down list from the cell, open. Attribute_Brands is a named range that should contain your list items. Use the drop down to the left of the formula bar to jump to the named range, then edit it. If you add or remove items you will need to adjust the range the named range covers. Pl2303 usb to serial driver for mac os x. Share improve this answer.
They are all correct. If I right click on the cell and choose 'pick from Drop down list.' It brings up the correct list, but the list is not in the correct place but a couple of inches to the right. OK, now after looking at this problem for several hours, I notice that if I scroll the worksheet so that this column is to the left of center of the screen, then the drop down list reappears. It seems that it has something to do with the position of the cell with respect to the screen, which would explain why I don't see the same problem on my 24' iMac, but only on my Macbook Air. The problem is though that it's a pain to always have to scroll this column to the left of center. It is some sort of bug with Excel 2016, version 15.18 (160109).