Applying Filters Excel In Telugu Part 18

Filtering is a convenient and reliable way to locate and manage spreadsheet data. You can filter data using the AutoFilter feature in Excel 2007 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, you can filter data by selecting criteria from a list, by numerical conditions, or by color. Here’s how to use the AutoFilter feature in Excel 2007.

Prepare your data for an Excel 2007 AutoFilter. Excel can filter the data in all selected cells within a range, as long as there are no completely blank rows or columns within the selected range. Once a blank row or column is encountered, filtering stops. If the data in the range you wish to filter is separated by blank rows or columns, remove them before proceeding with the AutoFilter.

Conversely, if there is data on the worksheet that you do not want to be part of the filtered data, separate that data using one or more blank rows or blank columns. If the data you don’t want to filter is located beneath the data to be filtered, use at least one completely blank row to end filtering. If the data you don’t want to filter is located to the right of data to be filtered, use a completely blank column.