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 Remove By Position
Remove characters by position from text in Excel If you ever want to remove a…
Excel Random Generator
Generate Random Data (Numbers, Date, String, etc…) Sometimes you want to generate some random data…
Excel Insert Title Rows
Insert Title Rows In Your Excel Range Sometime you may need to add a title…
Excel Hyperlinks Sheet Names
Convert All Your Worksheets into Hyperlinks in One Worksheet Extract all sheets names as hyperlinks…
Excel Batch Insert Option Buttons
Batch Insert Option Buttons In Excel Insert a batch of option buttons into selected cells…
How to insert a date picker in Excel
Add Date Pickers to Your Excel Sheets in No Time Effortlessly streamline data entry and…