How To Filter By Containing A Word Excel
How to brandish only rows with sure text in Excel?
In Excel, the Filter function is used widely in our daily piece of work. And in this instance, I introduce how to filter rows with certain text in Excel. For instance, here are two columns, and I want to bear witness the rows which contain "KTE" in cavalcade B only as below screenshot shown.
Show rows contain a specific cord by Filter office
Bear witness rows contains a specific string by Kutools for Excel 
Show rows contain a specific string by Filter office
To brandish rows that contain a cord, you can do as below:
1. Select the ranges you use, and click Data > Filter to enable the Filter part.
2. So click at the filter icon on the column you want to filter on, and select Text Filters > Contains. See screenshot:
three. In the Custom AutoFilter dialog, you lot can specify the text you want to filter based on. Encounter screenshot:
4. Click OK. Then only the rows which contain the text string yous specified are displayed.
Show rows contains a specific string by Kutools for Excel
If you usually use the aforementioned filter criteria beyond workbooks, yous tin can apply Kutools for Excel'southward Super Filter part, it tin save the filter settings for reusing easily with only several clicks, without reconfiguring information technology repeatedly.
Afterward installing Kutools for Excel, please do as below:( Gratuitous Download Kutools for Excel Now!)
1. Select the information you want to user, click Kutools Plus > Super Filter. Run across screenshot:
2. And then in the Super Filter pane, cheque Specified to prepare the filtering range, and specify the criteria as yous demand in the pane. See screenshot:
For more than filtering details, click this.
3. Click Filter to filter the range.
iv. And then click Relieve current filter settings button
, so a dialog pops out for you to give this scenario a proper noun, and specify the scenario applying range.
five. Click OK, and you can open up the scenario past clicking the drib-down carte > Open saved filter settings scenario to select the current saved scenario, or clickingManage filter settings scenarios button
, select the specified filter setting you desire, and and then click Open to enable the filter settings adjacent time.
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Bug, and Increases Your Productivity by eighty%
- Reuse: Quickly insert complex formulas, charts and annihilation that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
- Super Formula Bar (hands edit multiple lines of text and formula); Reading Layout (hands read and edit large numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns without losing Information; Split Cells Content; Combine Duplicate Rows/Columns... Preclude Duplicate Cells; Compare Ranges...
- Select Indistinguishable or Unique Rows; Select Blank Rows (all cells are empty); Super Notice and Fuzzy Find in Many Workbooks; Random Select...
- Verbal Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Excerpt Text, Add Text, Remove past Position, Remove Infinite; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
- Super Filter (salve and employ filter schemes to other sheets); Avant-garde Sort past month/week/day, frequency and more; Special Filter past bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. threescore-day coin back guarantee.
Office Tab Brings Tabbed interface to Role, and Make Your Piece of work Much Easier
- Enable tabbed editing and reading in Discussion, Excel, PowerPoint , Publisher, Access, Visio and Project.
- Open up and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
How To Filter By Containing A Word Excel,
Source: https://www.extendoffice.com/documents/excel/4447-excel-show-only-rows-with-certain-text.html
Posted by: bruntonthersellse1961.blogspot.com
0 Response to "How To Filter By Containing A Word Excel"
Post a Comment