how do you fix the drop down menu in excel 2016

This post is a roundup of articles on how to set up multiple selection Excel drop down lists. You can put it in some obscure location on the sheet so it isn't visible to the user.With a bit of Excel VBA programming, you can change an Excel data validation drop down list, so it allows multiple selections. This should stop the arrows from flashing/disappearing on the page with the combo box as well as all arrows in the whole workbook. BEST SOLUTION THAT REQUIRES NO MAJOR CHANGES: A strange solution that seems to work (for an unknown reason) is if you create a combo box (form control) and set the cell link and input range to =$1:$1048576 (this references all cells) on one of the sheets affected by the flashing arrows.Thus, you could move the linked cells that the camera tool is referencing to the same sheet with the dropwdown enabled cells. If the input cells of the camera tool object (the linked cells) are on the same worksheet as the data validation dropdown enabled cells, the problem doesn't exist.You could remove the camera tool object and everything should work fine.Again this may not be ideal or obvious for other users. You can also click on the dropdown enabled cell and hit Alt-Downarrow, and the list will appear.It works, but it's annoying and makes it difficult for other users if the worksheet is intended for users other than yourself. You can still access the dropdown if you select the dropdown enabled cell and move the cursor to the right where the arrow would normally appear and click.

If you used the camera tool, then if the input cells of the camera tool object (the linked cells) are on a different worksheet as the data validation dropdown enabled cells, the dropdown arrows go missing. This appears to be a bug in some versions of excel.

How do you fix the drop down menu in excel 2016