How To Use Advanced Text Filters
Advanced text filters can be used to display more specific information, like cells that contain a certain number of characters or data that excludes a specific word or number.
Step 1: Click the drop-down Arrow for the Column you want to Filter
Step 2: The Filter menu will Appear
Step 3: Go to the Text Filters
Go to the Text Filters then select the desired text filter from the dropdown menu.
Step 3: Enter the Desrired Text in the Cutsom AutoFilter dialog box
The Custom AutoFilter dialog box will appear. Enter the desired text to the left of the Filter, then click ok.
Step 4: Preview the Filtered Data
The data is now filtered by the selected text filter.
How to Add, Use and Remove Filter in Excel
Working with a database is a crucial job. With every data added increases the comprehensiveness to manage records and pick out the needed information from any corner of the database. Keeping the struggle in mind, Excel is a great tool to store and extract data in a hassle-free manner.
The filter option provides efficiency in searching for the needed data from a huge pile of records. Let’s understand what exactly the filter option is. The filter in Excel displays data that is relevant for the users to make decisions. The user applies some criteria and the records get separated wherein required data show up and others disappear.
Contact Us