Forum Discussion

HiQ's avatar
HiQ
Copper Contributor
Jun 25, 2026
Solved

Help needed to filter in Excel please

How do I filter our spreadsheet to populate a list with only lines containing the search word? For example: 18598-Ensign, 6 - 3 POSITION TIE LUGS, RIG 141 18599-Ensign, 6 - 3 POSITION TIE LU...
excel
  • NikolinoDE's avatar
    NikolinoDE
    Jun 30, 2026

    Here’s the easiest way to filter your spreadsheet to show only rows that contain "Ensign" (or any other word you choose).

    Use AutoFilter

    If your data is in one column:

    1. Select your data (or click any cell in the list).
    2. Go to Data → Filter.
    3. Click the filter drop-down arrow on your column.
    4. Choose Text Filters → Contains...
    5. Type Ensign.
    6. Click OK.

    You'll only see rows containing "Ensign".

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

     

    Was the answer useful? Mark as best response and like it!

    This will help all forum participants.

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jun 30, 2026

Here’s the easiest way to filter your spreadsheet to show only rows that contain "Ensign" (or any other word you choose).

Use AutoFilter

If your data is in one column:

  1. Select your data (or click any cell in the list).
  2. Go to Data → Filter.
  3. Click the filter drop-down arrow on your column.
  4. Choose Text Filters → Contains...
  5. Type Ensign.
  6. Click OK.

You'll only see rows containing "Ensign".

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

 

Was the answer useful? Mark as best response and like it!

This will help all forum participants.