You can set properties of a DataPilot table to ignore empty
rows, identify categories, calculate grand totals, and keep table
formatting.
- Click .
- On the DataPilot menu, select DataPilot
Table Option. In the window, select one of the following
options:
- Ignore empty rows – Ignores empty fields
in the data source.
- Identify categories – Automatically
assigns an empty row with the values from the preceding row.
- Total columns – Calculates and displays
the grand total of the column calculation.
- Total rows – Calculates and displays
the grand total of the row calculation.
- Enable show details – Double click
cells of row or column in DataPilot table, some data can be displayed
or hidden with this option enabled. Double click cells of data area
in DataPilot table, a new sheet which contains the related source
data is created with this option enabled.
- Automatically resize column width –
DataPilot table column width is auto-resized to fit the width of the
contents when data changed in the DataPilot table with this option
enabled.
- Preserve formatting – Preserves formatting
for Field and Data areas with this option enabled.