Hello,
Is it possible to sort my AutoCat list alphabetically? I’m afraid to try it on my own by first adding a filter & then sorting because I don’t want to mess up any formulas. Each time I add a category to AutoCat I want to be able to see it in alphabetical order so I can easily see if I’ve already added something to the list to prevent duplicates.
Hi @rekha.tadoori,
Yes, you can sort your rules.
Keep the following in mind if you do sort them alphabetically:
Rule processing order
The rules are processed in a top down order, so put your most fine grained (specific with more criteria) rules at the top of the sheet and broader (generic less criteria) rules lower down.
You can sort the AutoCat sheet using the built-in filter features in Excel. Be sure to turn the filter on before trying to sort in Excel. The header (blue) row must remain at the top and trying to sort without turning on the filter feature can cause the header row to move out of position 1.
Clint
thank you very much!
1 Like