Microsoft Office Tutorials and References
In Depth Information
Filter or Sort Table Information
10
CHAPTER
EXCEL
Worksheet Basics
Sort a Table
1 Click next to the column
heading you want to use for
sorting.
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
information.
F
changes to to indicate
the data in the column is
sorted.
TIPS
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
I do?
Click the Data tab and then click the Filter
button. This button toggles on and off the
appearance of the AutoFilter
in a table.
185
Search JabSto ::




Custom Search