Filter By Selection

 Filtering is done by many ways and here we see how we can filter by selecting the text in Excel.

1.  In a range of cells or table column, right click a cell containing the value, color, font color, or icon that you want to filter by.
 

2. Click Filter, and then do one of the following:

• To filter by text, number, or date or time, click Filter by Selected Cell's Value.
• To filter by cell color, click Filter by Selected Cell's Color.
• To filter by font color, click Filter by Selected Cell's Font Color.
• To filter by icon, click Filter by Selected Cell's Icon.

 

3. To reapply a filter after you change the data, click a cell in the range or table and then, on the Data tab, in the Sort & Filter group, click Reapply.

Posted in: Filter by Selection,Filters,Microsoft Excel 2007,Microsoft Office Support,PC Support,Technical Support,TechSupp247