Adding an Excel file filter

There are two default filters for Excel: Default Excel filter, and Default Excel 2007 filter. The steps for adding both filters are the same. In the example below, a Default Excel filter will be added.

To add an Excel file filter:

  1. Follow steps 1 and 2 from Viewing default file filters.
    The Formats dialog box appears. The default filters appear in the Available Formats box.

  2. Select Format Type as Default Excel Filter.
    The Excel Filter options appear.

  3. Click Setup.
    The Choose Excel File... dialog box appears.

  4. Select an Excel file and click Open.
    The Excel Column Selection Wizard appears.

  5. Read the instructions carefully and click Next.
    The Select Wizard type page appears.

  6. Select the wizard type. You have two options: