Sunday, July 17, 2011

How to Set the Advanced Filter in Microsoft Excel 2003


1. Open the advanced filter properties box. Scroll to “Data” and click on “Filter.” Select “Advanced Filter” from the submenu.
2. Set the list range. Click on the “List Range” field to activate it and then scroll with cursor as you depress the mouse button and highlight the range of cells and columns that you wish to filter; the information will automatically be added to the field; or you can enter the range of cells in Excel format on your own.
3. Set the criteria range. Click in the “Criteria Range” filter and then click on a single cell in the workbook which contains the criteria; it will automatically be entered into the field.
4. Implement the advanced filter. Check the box labeled “Unique Records Only” if you do not wish to see duplicate records. Click on the “OK” button to implement the advanced filter.

Blogger news