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.
Excel If your Excel version supports Dynamic Arrays use the SORT function on a column in a structured table that contains the cars.
See attached.
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)?