Forum Discussion
Solved
Query related to drop down
Hello Everyone, I have created dropdown list with the help of Name Range. So, how to add custom sort rule like when the new value added to list means it should not go and sit at bottom but ins...
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.
This is a nice method.
So what should i put formula to apply this process and connected to Cars column and it should be dynamic ?
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.
- Ok, Thank you so much sir