![]() The macros will not work with data validation drop down lists that are based on the following: The multiple selection techniques dexcribed below will only work with drop down lists that are based on a named range. Those lists are used to set up the data validation drop down lists on the data entry sheet. MonthList - list of months, in cells C1:C12.DayList - list of weekdays, in cells A1:A7.On another worksheet in that Excel file, there are two named lists: Select "Tuesday" from the drop down list, to add it to the active cell. The selected item is automatically entered in the cellįor example, in the screen shot below, there is an Excel table, with drop down lists for Day and Month.Then, select a cell, and click its drop-down arrow.Add drop down lists to your worksheets, using the Excel data validation feature.To make data entry easy, you can follow these steps: More Tutorials Select Items From Drop Down List
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |