Click anywhere within the table range.
Click the Data tab.
Click the Sort button.
![Click anywhere within the table range. Click the Data tab. Click the Sort button.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Sort_Table_Using_Multiple_Fields_And_Attributes___Click_Anywhere_Within_Table_Range_C.PNG)
Click the Column list arrow and then select a sort field.
![Click the Column list arrow and then select a sort field.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Sort_Table_Using_Multiple_Fields_And_Attributes___Click_Column_List_Arrow_And_Then_Se.PNG)
Click the Sort on and select: Values, Cell Color, Font Color, or Cell Icon.
![Click the Sort on and select: Values, Cell Color, Font Color, or Cell Icon.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Sort_Table_Using_Multiple_Fields_And_Attributes___Click_Sort_On_And_Select_Values_Cel.PNG)
Click the Order and select a sort field: A to Z, Z to A, or Custom List.
![Click the Order and select a sort field: A to Z, Z to A, or Custom List.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Sort_Table_Using_Multiple_Fields_And_Attributes___Click_Order_And_Select_Sort_Field_T.PNG)
To add another level of sorting, click Add Level.
![To add another level of sorting, click Add Level.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Sort_Table_Using_Multiple_Fields_And_Attributes___To_Add_Another_Level_Of_Sorting_Cli.PNG)
To change the sort order, select a sort, and then click Move Up or Move Down.
![To change the sort order, select a sort, and then click Move Up or Move Down.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Sort_Table_Using_Multiple_Fields_And_Attributes___To_Change_Sort_Order_Select_Sort_An.PNG)
To delete or copy a sort level, select a sort, and click Delete Level or Copy Level.
![To delete or copy a sort level, select a sort, and click Delete Level or Copy Level.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Sort_Table_Using_Multiple_Fields_And_Attributes___To_Delete_Or_Copy_Sort_Level_Select.PNG)
Click OK.
![Click OK.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Sort_Table_Using_Multiple_Fields_And_Attributes___Click_Ok.PNG)