Microsoft Office Tutorials and References
In Depth Information
Filter a Range or Table
Filter a Range
or Table
You can analyze table data much faster by only
viewing those table records that you want to work
with. In Excel, this is called filtering a range.
The easiest way to filter a range is to use the Filter
buttons, each of which presents you with a list of
check boxes for each unique value in a column.
You filter the data by activating the check boxes for
the rows you want to see. If you have converted the
range to a table, as described in Chapter 10, the
Filter buttons for each column are displayed
automatically.
Filter a Range or Table
Display the Filter Buttons
Note: If you are filtering a
table, you can skip directly
to the “Filter the Data”
subsection.
1 Click inside the range.
2 Click the Data tab.
3 Click Filter (
).
A Excel adds a Filter button
( ) to each field.
Filter the Data
1 Click for the field you
want to use as the filter.
Search JabSto ::




Custom Search