
To Filtering is a convenient and reliable way to locate and manage
spreadsheet data. We can filter data using the AutoFilter feature in Excel 2007-2010
to display only the data that meets specified criteria. Filtered data
can be copied, manipulated, and printed without having to move it to a
new spreadsheet. Using AutoFilter, we can filter data by selecting criteria from a list, by numerical
conditions, or by color. Here's how to use the AutoFilter......