Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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.