Forum Discussion
Query related to drop down
Excel Well, since you are working with an outdated Excel version it's not going to be more dynamic than that. At least, not when you want to add new entries at the bottom of the table. Consider entering new car makes at the top then. Right-click on the first cell in the Car column.
Because i am using Microsoft Office 2019 Home and Student
Please
Excel Then just point the data validation list to the Cars column in the table and Sort that column. Then the dropdowns will be in the same order and the list will automatically expand when you add cars at the bottom of the table.
See attached.
When i insert new data (Lamborghini), it is not come first in dropdown list.
Here is a attached fileExcel Perhaps I misunderstood the phrase "it should be placed under its first letter value".
Don't you want the Cars brands to be sorted in alphabetical order (A to Z)?
- Sir ,When I update any data, that data should appear in the first in drop down list in data validation.