Filter Wildcard Characters

In this post, you are going to learn how to use wildcard characters in the filter to easily extracts list in a sheet and to know use of search box in menu.

We have a worksheet that has big data with multiple values in a column to know how many items payment we get in cash form.

Download Your Example Excel File

To Use Search box for Filter

  • Open an Excel File
  • Click the data tab
  • Under sort & filter group click filter
  • Click the arrow appear at the top
  • The menu appears in search type (*h)

All characters that end with the letter “h” will show others are hidden from the table.

Remember:  To view how wildcard character works to Find and Replace.

Note: Please know detailed about Sort and Filter feature in Excel.