The size of the columns in a DataPilot table can be changed
automatically when you update the contents of the table.
Follow these steps to automatically resize column widths:
- Select a DataPilot table.
- Right-click the DataPilot table and select DataPilot
Table Option.
- In DataPilot Table Option window,
select Autoresize column widths when update.
- The column width is automatically resized to fit the
width of the contents when data is changed in the DataPilot table.
Actions that impact the column width include changing the DataPilot
table layout by adding, moving, or removing fields, changing the filter
rule to change the display range or changing the text length in the
source data.