Microsoft Office Tutorials and References
In Depth Information
Working with Tables
Figure 9-6: Each column in a table contains sorting and filtering options.
Sorting a table
Sorting a table rearranges the rows based on the contents of a particular column. You may want
to sort a table to put names in alphabetical order. Or, maybe you want to sort your sales staff by
the total sales made.
To sort a table by a particular column, click the drop-down arrow in the column header and
choose one of the sort commands. The exact command varies, depending on the type of data in
the column. Sort A to Z and Sort Z to A are the options that appear when the columns contain
text. The options for columns that contain numeric data or True/False are Sort Smallest to
Largest and Sort Largest to Smallest. Columns that contain dates change the options into Sort
Oldest to Newest and Sort Newest to Oldest.
You can also select Sort by Color to sort the rows based on the background or text color of the
data. This option is relevant only if you’ve overridden the table style colors with custom colors, or
if you’ve used conditional formatting to apply colors based on the cell contents.
When a column is sorted, the drop-down control in the Header row displays a different
graphic to remind you that the table is sorted by that column. If you sort by several
columns, only the column most recently sorted displays the sort graphic.
You can sort on any number of columns. The trick is to sort the least significant column first and
then proceed until the most significant column is sorted last.
For example, in the real estate listing table, you may want the list to be sorted by agent. And
within each agent’s group, the rows should be sorted by area. And within each area, the rows
should be sorted by list price. For this type of sort, first sort by the List Price column, then sort by
the Area column, and then sort by the Agent column. Figure 9-7 shows the table sorted in this