Excel 2003 can filter a large number of data that is created or imported into the programme. Filtering data in Excel 2003 will find and display only the records you want to work with and is most accepted when you want to find single records or work with a subset of the data in an Excel 2003 document.
Excel 2003 offers an Auto Filter feature that enables you to recognize cells that include a definite quest term, or multiple cells that meet your quest criteria. You can also invent custom filters that help you find definite data within cells.
Personalized Labels
When filtering data in Excel 2003 via the Auto Filter function, Excel will retrieve all records that meet your quest criteria and hide all records that don't. This is particularly helpful if you are attempting to standardise data, find errors or blank cells within the data.
To filter your data using Auto Filter, go for Data > Filter > AutoFilter. Your column label will become a pull-down menu. All unique entries in that column will be listed in the pull-down, along with the choices (All), (Top 10...) and (Custom...). You can go for your filtering criterion for the column by choosing it from the pull-down menu. To use multiple filtering criteria from a single column, you must generate a Custom Auto Filter for those criteria.
To generate a Custom Auto Filter, turn Auto Filter on. You can do this by toggling the Auto Filter button on the accepted toolbar. Click the gray arrow in the column header and go for Custom... From the list of choices. This will inaugurate the Custom Auto Filter dialogue box.
Within this dialogue box, you will be able to select the best ways to limit your filters and provide an exact filtering term. You can also select a second set of filtering criteria and indicate whether you want the criteria Anded or Or'd. Once your filter is set, click Ok and your data will be filtered agreeing to your criteria. Rows that do not meet your filtering criteria will be hidden. They will not be removed from the document! You may edit the data within the rows you're working with.
When you have finished filtering data in Excel 2003, you may deselect in the accepted toolbar to turn the feature off. All rows of data will be descriptive in your document.
Filtering Data In Excel 2003