![]() Select the ranges you use, and click Data > Filter to enable the Filter function.Ģ. To display rows that contain a string, you can do as below:ġ. Show rows contains a specific string by Kutools for Excel Show rows contain a specific string by Filter function For instance, here are two columns, and I want to show the rows which contain “KTE” in column B only as below screenshot shown. And in this case, I introduce how to filter rows with certain text in Excel. ![]() ![]() ![]() In Excel, the Filter function is used widely in our daily work. How to display only rows with certain text in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |