Page 150 - Excel 2007 Bible

10_044039 ch06.qxp 11/21/06 10:57 AM Page 107
Introducing Tables
You can filter by multiple values — for example, filter the table to show only N. Country and Central.
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 column. 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 values). 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.
As you may expect, the Total Row is updated to show the total only for the visible rows.
NOTE
NOTE
Why you copy data from a filtered table, only the visible data is copied. In other words, rows that are hid-
den 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 that the pasted data is not a table — it’s just a normal
range.
To remove filtering for a column, click the drop-down in the Row Header and select Clear Filter. If you’ve 6
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.

107