After the Version 09) update the drop down arrow disappeared. If you move the cursor to the right side of the cell (or the left side of the adjacent cell where the arrow should be) the cursor changes to a pointing hand (like it does when the arrow was there). If you click there the list shows up. Any ideas on how to get the drop down arrow to reappear?
![Drop Down Option Not Showing In Excel For Mac Drop Down Option Not Showing In Excel For Mac](/uploads/1/2/5/4/125495729/159559802.png)
It is very confusing for someone that is told to select the appropriate choice from the drop down Thanks in advance. Starting in SAFE Mode did not change anything. Using the Move or Copy Sheet function did not work either. Nothing changed - the drop down arrows are not visible when you select the cell BUT if you move your cursor to the right side of the selected cell (or the left side of the adjacent cell to the right) where the drop down arrow should be - and click there (because the cursor changes to a pointing finger) the drop down list appears and you can select the value you want.
Nov 21, 2018 - Add a drop-down list for data entry in Excel. To Excel versions 2019, 2016, 2013, 2010, Excel Online, and Excel for Mac. Create a Drop-Down List. Screenshot of Excel showing how to select a source for data validation. If you move the drop-down list to a new location on the same worksheet, it's not.
Creating a new sheet the arrows are visible!!!!!! All arrows are also visible if I open these files on a WINDOWS computer. On the file example you have from me there are drop down (Data Validation) arrows in cells A3 to C4002 and cell D1 The only thing that changed is these files were created on a MAC with Update 16.16 and when Update 16.17 ran the arrows became invisible.