Microsoft Office Tutorials and References
In Depth Information
Creating a custom sort list
Sort using a custom list
1 Click any cell in the list that you want to sort.
2 Click the Data tab.
3 Click Sort.
4 Click the Sort By down arrow and then click the column that you
want to sort by.
5 Click the Sort On down arrow and then click the criteria that you
want to sort by.
6 Click the Order down arrow and then click Custom List.
7 Click a custom list.
8 Click OK to close the Custom Lists dialog box.
9 Click OK to sort the data list.
3
2
4
5
6
1
7
9
TIP In versions of Excel prior to Excel 2007, you could use a
custom list to sort only one column of your worksheet data and that
column had to be the first by which you sorted your data. In Excel 2013, you
can sort any number of columns according to the values in a custom list.
8
Search JabSto ::




Custom Search