Microsoft Office Tutorials and References
In Depth Information
Filter or Sort Table Information
Sort a Table
1 Click next to the column
heading you want to use for
D Excel displays a list of
possible sort orders.
2 Click a sort order.
This example sorts from
smallest to largest.
E Excel reorders the
changes to to indicate
the data in the column is
How does the Sort by Color option work?
If you apply font colors, cell colors, or both to some cells in
the table, you can then sort the table information by the
colors you assigned. You can manually assign colors or you
can assign colors using Conditional Formatting; see Chapter
9 for details on using Conditional Formatting.
I do not see the AutoFilter down arrow
beside my table headings. What should
Click the Data tab and then click the Filter
button. This button toggles on and off the
appearance of the AutoFilter
in a table.