Another type of filter is the standard filter. To use this filter, select the range you want to filter then select “filter” from the data menu. Choose the standard filter option.

Some of the filter options are hidden by default. You can access these functions by clicking the “more” button.

The standard filter screen will let you define up to three filter conditions by specifying a field name, condition, value and an operator.

Suppose that you wanted to find all items that grow in full sun, have a fast growth rate and a price less than $15.00.

You would select light requirements as the filter field. Select “equals” as the condition and select full sun as the value.

Next you want to add a condition to display only the items that have a rapid growth rate. Select “and” as the operator, growth rate as the field, “equals” as the condition, and “Rapid” as the value.

The final condition is to only show items less than $15.00 in price. Again, select “and” as the operator, then select price as the field. This time the operator will be “less than” and the value will be 15.

Click the OK button and we'll see the list filtered to show only the items that require full sun, have a rapid growth rate, and cost less than 15 dollars.

To remove a standard filter select the filter option from the data menu, then select remove filter.