Microsoft Office Tutorials and References
In Depth Information
hide the drop-down arrows by selecting that command again. You can also use
Data ⇒ Sort & Filter ⇒ Filter to hide the drop-down arrows in a table.
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.