![]() (add) For each of the pasting options, change the dropdown menu to Keep. 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. The Advanced screen on the Word Options dialog box displays In Excel 2010 or a. 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. I have not been able to locate Microsoft Date & Time Picker Control under INSERT in Active X Control as recommended in some tutorials. This is how you fix it: Under File - go to Options, and then go click on Advanced. ![]() I am not savvy when it comes to VBA codes. For those who say you have to create a new sheet - nahhhh you dont. To achieve this, right click on the sheet tab of Sheet2 and click on Hide. Note: if you don't want users to access the items on Sheet2, you can hide Sheet2. On the second sheet, type the items you want to appear in the drop-down list. Write the desired drop-down menu options in a list. To create a drop-down list in Excel, execute the following steps. It can be in the same sheet, another sheet, or another Excel file. Pick anywhere you want to store the drop-down list items. It is fortunate that I had not changed the architecture of the file at all, so the sheet names + cell numbers were accurate. Please I use Excel 2016 and I’d like to create a drop down calendar that insert date into a separate cell. But before you insert the drop-down list you need to decide what data entries should be allowed. 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"). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |