Excel: Sounds Good Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 More

Home -> Sort and Filter -> Filter

Filter the Data A Filter displays certain rows based on the criteria you select. The rows that don't match the filter are simply hidden: they are not deleted. A Filter is a way to focus your investigations.   You worked with Filters when you created a table in Excel. This is how to add your own Filters.   Try it: Filter the Text Copy the Original Data sheet. Name the new sheet: Filtered. Select the first row. Go to Home -> Sort and Filter. Select Filter.     Memo to Self: This is another good  example of a function that uses the fields in the header row, the first row in a spreadsheet.