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.