Page 224 - CA_165_V2.0_C9_Flipbook
P. 224
FILTER
Filtering is a quick and easy way to get required information from a subset of data in a range of cells. A
filtered range displays only the data that meet the criteria specified for a field. In OpenOffice Calc, there
are three options that help in filtering the range of data:
Filter Type Description
AutoFilter It filters data according to specific value or string.
Standard Filter It filters the data according to a given condition.
Advanced Filter It does more advanced filtering, on the basis of specific criteria.
Unlike sorting, filtering does not rearrange a range of cells. Filtering temporarily hides the rows that
are not required to be displayed. It allows you to edit, format, and even print the range subset without
rearranging or moving it.
To filter a range of data, follow these steps:
Step 1: Select the entire data range that you want to filter, including headers.
Step 2: Click the Data menu on the menu bar.
Step 3: Click the Filter option from the drop-down menu. A submenu will appear.
Step 4: In the submenu, select the AutoFilter option. Drop-down arrows will appear in front of all the
column headers or the column header range of the selected data.
2
3 4
1
Step 5: Click the drop-down arrow in front of the Grade column header.
Step 6: Select All or the required criteria A, B, or C. The rows that satisfy the criteria will be visible, and
the rest of the rows will be hidden.
5
6
222 Touchpad Computer Applications (Ver. 2.0)-IX

