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.
doc display rows with certain text 1

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.
doc display rows with certain text 2

2. So click at the filter icon on the column you want to filter on, and select Text Filters > Contains. See screenshot:
doc display rows with certain text 3

three. In the Custom AutoFilter dialog, you lot can specify the text you want to filter based on. Encounter screenshot:
doc display rows with certain text 4

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:
doc display rows with certain text 5

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:
doc kutools super filter 1

For more than filtering details, click this.

3. Click Filter to filter the range.
doc kutools super filter 3

iv. And then click Relieve current filter settings button doc save , so a dialog pops out for you to give this scenario a proper noun, and specify the scenario applying range.
doc kutools super filter 4

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 doc manager , select the specified filter setting you desire, and and then click Open to enable the filter settings adjacent time.
doc kutools super filter 5
doc kutools super filter 6

Tip. If y'all want to take a free trial of the Super Filter role, please go to free try Kutools for Excel offset, and so go to utilize the operation according above steps.

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.

kte tab 201905

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!

officetab bottom