Chapter 5: Introducing Tables
113
You can filter by multiple values in a column by using multiple check marks. For example, to filter
the table to show only N. County and Central, place a check mark next to both values in the drop-
down list in the Area Row Header.You can filter a table using any number of columns. For example, you may want to see only the N.
County listings in which the Type is Single Family. Just repeat the operation using the Type col-
umn. All tables then display only the rows in which the Area is N. County and the Type is Single
Family.For additional filtering options, select Text Filters (or Number Filters, if the column contains val-
ues). The options are fairly self-explanatory, and you have a great deal of flexibility in displaying
only the rows that you’re interested in.In addition, you can right-click a cell and use the Filter command on the shortcut menu. This
menu item leads to several additional filtering options.Note
As you may expect, the Total Row is updated to show the total only for the visible rows. n
When you copy data from a filtered table, only the visible data is copied. In other words, rows that
are hidden by filtering don’t get copied. This filtering makes it very easy to copy a subset of a larger
table and paste it to another area of your worksheet. Keep in mind, though, that the pasted data is
not a table — it’s just a normal range. You can, however, convert the copied range to a table.To remove filtering for a column, click the drop-down in the Row Header and select Clear Filter. If
you’ve filtered using multiple columns, it may be faster to remove all filters by choosing Home ➪
Editing ➪ Sort & Filter ➪ Clear.Converting a table back to a range ..........................................................................
If you need to convert a table back to a normal range, just select a cell in the table and choose
Table Tools ➪ Design ➪ Tools ➪ Convert to Range. The table style formatting remains intact,
but the range no longer functions as a table.