Excel: Work Smarter Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Filter the Data

Too much data-too many rows of information-is just inyourface noise. A Filter is a simple method for analyzing your data. Filters use the labels in the Header Row to show or hide the rows of data.

 

Try it: Filter the Data

Make a copy of the Original Data worksheet. Rename it 2007 Sales Filtered.

 

Select the entire spreadsheet

Go to the Data tab

Click on Filter

Data -> Filter