ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to force a Default sort for a validation list (https://www.excelbanter.com/excel-discussion-misc-queries/83673-how-force-default-sort-validation-list.html)

scott56hannah

How to force a Default sort for a validation list
 
I have setup a validation list from a defined name in a spreadsheet.

The list originally was displayed in an alphabetic sort from A-Z.....at some
point this was reversed and now sorts from Z-A.....

Is there anyway to reverse this back to the default sort order....I have
tried removing the validation list and re-addiing it without success.


All times are GMT +1. The time now is 01:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com