Selecting Pivot Table Output Ranges
Click the button \<emph\>More\</emph\> in the \<emph\>DataPilot\</emph\> dialog. The dialog will be extended.
You can select a named range in which the DataPilot table is to be created, from the \<emph\>Results to\</emph\> box. If the results range does not have a name, enter the coordinates of the upper left cell of the range into the field to the right of the \<emph\>Results to\</emph\> box. You can also click on the appropriate cell to have the coordinates entered accordingly.
If you mark the \<emph\>Ignore empty rows \</emph\>check box, they will not be taken into account when the DataPilot table is created.
If the \<emph\>Identify categories\</emph\> check box is marked, the categories will be identified by their headings and assigned accordingly when the DataPilot table is created.
