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:
How to Remove Leading Or Trailing Or Extra Spaces In Excel
Remove Leading Or Trailing Or Extra Spaces From Excel Cells You can remove leading spaces,…
Excel How to Remove Only Text Or Only Numbers
Remove text or numbers or symbols from cells in Excel You can remove only text…
Excel Clean Data
Clean Data In Excel Clean data in huge Excel sheets could take long time doing…
Compare Lists in Excel
Compare Lists in Excel If you ever want to compare lists by looking up for…
Excel Count Worksheets
Count Sheets In Excel Count sheets in Excel whether visible or hidden, a window will…
Excel Select Merged Cells
Quickly Select Merged Cells It seems a little difficult to select only merged cells in…