how do you add a drop down menu in excel 2016

Welcome to my blog about Vba Excel Function Macro Creating A Drop Down List Stack Overflow, where I explore the fascinating world of Vba Excel Function Macro Creating A Drop Down List Stack Overflow and share my insights with you. I could now see the validation under 'Data' / 'Data validation', but not the drop-down menu buttons, so I applied nwidnsor 's advice and now it seems to be working fine.Vba Excel Function Macro Creating A Drop Down List Stack Overflow. To make sure I minimize intervention and I don't lose any existing information, I only pasted the data validation cells where I would add new entries - so the old entries are not linked to my lists anymore. It is fortunate that I had not changed the architecture of the file at all, so the sheet names + cell numbers were accurate. I couldn't solve it following the above advice, so I actually manually copy-pasted the cells with data validation from a quite older back-up version of the file that I had stored in the old PC (which was never copied to the 'new' PC). Interestingly, this was the case for all recent back-up files I had created in the new PC, when I tried to open them again in the old PC. I created the file and used it for months (maybe 2-3 times a month) on a certain PC, then copied it & used it on another PC for about 10 days more intensely, then back to original PC and the data validation was instantly gone.

I had a similar problem, only my cells had lost altogether the data validation (and the 'For objects, show' option was set to 'All').

How do you add a drop down menu in excel 2016