Sorting Data in a Table : Table Sort « Table « Microsoft Office Excel 2007 Tutorial






Click the table cell with the field name. 
           Click the Data tab. 
           Click the Sort Ascending or the Sort Descending button.
Click the table cell with the field name. Click the Data tab. Click the Sort Ascending or the Sort Descending button.
The list arrow displays an icon indicating the field is sorted.
The list arrow displays an icon indicating the field is sorted.
To clear all filters in a worksheet and redisplay all rows, click the Clear button.
To clear all filters in a worksheet and redisplay all rows, click the Clear button.
To reapply a filter, click the Reapply button.
To reapply a filter, click the Reapply button.








4.5.Table Sort
4.5.1.Sorting Data in a TableSorting Data in a Table
4.5.2.Sort across a rowSort across a row
4.5.3.Sort a Table Using Multiple Fields and AttributesSort a Table Using Multiple Fields and Attributes
4.5.4.Sort data with the case sensitive optionSort data with the case sensitive option