Excel Filter By Selected Value

Excel Fast Filter

To not wasting time by navigating to Data tab and click on filter then going to the column to filter it with typing the value to be filtered at, you simply can use this utility Filter to do it faster as explained in below. Dose for Excel‘s Filter utility can easily do this with one click.

Click DOSE » Filter

Excel Filter By Selected Value

Usage:

  1. Select a cell that you want to filter the whole column according to it.
  2. And then click DOSE » Filter. The utility will filter the column based on the selected cell value. If you want to clear the filter then Click DOSE » Clear to clear the current filter. In below example, we filter the column “B” with value “Accountant”. See screenshots:

More Features:

Excel Color Duplicates

Color Duplicated Cells Values In Groups In Excel Color the duplicated cells values, each group…

Excel Sort Sheets

Sort Sheets by alphanumeric or date In Excel Sort your sheets in your current workbook…

Excel Merge

How to Merge Cells in Excel Merging cells is a common practice when working with…

Excel Delete Columns

Highlight Or Delete Any Type Of Columns Highlight or delete identical, empty, or hidden cell…


Scroll to Top