Part I: Getting Started with Excel
FIGURE 4.21
Each column in a table has sorting and filtering options.
If you don’t plan to sort or filter the data in a table, you can turn off the display of Filter Buttons in a table’s header
row. Choose Table Tools Design ➪ Table Style Options ➪ Filter Button to display or hide the drop-down arrows.
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 Filter Button in the column header and
choose one of the sort commands. The exact command varies, depending on the type of
data in the column.
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 cus-
tom formatting.
