Microsoft Office Tutorials and References
In Depth Information
Luckily, Excel has a very useful feature—Custom Lists—to provide custom sorting. Unluckily,
this feature is very well hidden in the Excel user interface. Nevertheless, let us describe it.
The Custom Lists feature, as its name suggests, is simply a list of sorted values that Excel
can use to show a different sorting.
You can find the Excel Custom Lists item among the Excel options, at the end of the
Advanced page, as you can see in Figure 8-5.
FIguRE 8-5 Excel Custom Lists is located on the Advanced page of the Excel Options dialog box.
When you open the Custom List dialog box, you can see some custom lists that are shipped
with Excel and provide custom sorting for weekdays and month names, localized in your
Excel language, as you can see in Figure 8-6.
You can add as many custom lists as you need by listing the values directly into this window
or by using an Excel workbook that already contains the sorted list. Now the interesting
part of this procedure is that even if month names are present in this window, PowerPivot
still refuses to sort month names using the custom list and uses alphabetical ordering