Microsoft Office Tutorials and References
In Depth Information
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. For example, you can filter the table to show only rows that contain the
same value as the active cell.
As you may expect, the Total row (if present) is updated to show the total for the visible
When you copy data in a filtered table, only the visible rows are 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.
Figure 9-9: Filtering a table to show only the information for N. County.