Filtering By Selection
Even without filter ignited, you can right-click any cell in a column, outward journey to filter, and choose to filter by the value of the cells, the color, the color of police, or the icon. To make will thus start the filter and will configure the filter for the property of the selected cells.
Filtering is additive. If you filter a cell by a value and then go to a cell in another column and filter by its value, the result will be these lines which answer the two criteria of filter. You cannot filter by a property more once in the same column, but you can filter a column by multiple property-for the example, filters by the icon and then to evaluate it.
Using Filter Selection
To use filter selection to view records meeting a specific value and font color, follow these steps:
1. | Right-click a cell containing the value to filter by.
|
2. | Go to Filter, Filter by Selected Cell’s Value.
|
3. | Right-click a cell containing the font color to filter by.
|
4. | Go to Filter, Filter by Selected Cell’s Font Color. |
Allow Filtering on a Protected Sheet
Normally, if you set up filters on a sheet, protect
the sheet, and then send it out to other users, the recipients won’t be
able to filter the data. If you want others to be able to filter your
protected sheet, follow these steps:
|
If filtering an existing table, skip to step 3.
|
1. | Select a single cell in the dataset to apply filtering to.
|
2. | Go to Home, Sort & Filter, Filter. The filter will be turned on for the dataset.
|
3. | Go to Review, Changes, Protect Sheet.
|
4. | In the listing for All Users of This Worksheet To, scroll down and select Use AutoFilter.
|
5. | If applying a password to the sheet, enter it in the Password to Unprotect Sheet field. Otherwise, skip to step 6. |
6. | Click OK.
|
7. | If you entered a password in step 5, Excel will prompt you to reenter the password. Do so and click OK. |
