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
Usage:
- Select a cell that you want to filter the whole column according to it.
- 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 Advanced Functions
Use Built-In Advanced Functions In Excel You can quickly use built-in functions without writing VBA…
Excel Insert Title Rows
Insert Title Rows In Your Excel Range Sometime you may need to add a title…
How To Color Alternate Row In Excel
Color alternate row or column in Excel With this utility you can quickly apply shading…
Excel Compare Sheets
Compare Sheets In Excel Comparing Excel sheets will take long time if doing it manually,…
Excel Color Duplicates
Color Duplicated Cells Values In Groups In Excel Color the duplicated cells values, each group…
Excel How to Remove Only Text Or Only Numbers
Remove text or numbers or symbols from cells in Excel You can remove only text…