Change column widths

PowerTable provides multiple ways to adjust column widths to optimize the display of data in tables with many columns.

You can resize columns by dragging column headers, automatically fitting columns to their headers or content, or specifying widths manually.

Resize columns manually

The quickest way to resize a column is to drag its header boundary.

To resize a column manually:

1. Hover over the edge of the column header.

2. Drag the resize handle to the required width.

   

Auto-fit column widths

Use the Auto Fit options to automatically adjust column widths based on the header or content.

To access the available auto-fit options:

1. Go to the Format tab.

2. Select the Auto Fit dropdown.

   

Fit to header

Select Fit to Header to resize each column based on the width of its column header.

Fit to content

Select Fit to Content to resize each column based on the width of the data it contains.

Set column widths manually

Use Manage Columns to specify exact column widths in pixels.

To set column widths manually:

1. Select PowerTable > Manage Columns.

2. Enter the required width in pixels for the appropriate columns.

   

To restore the original column widths, select Reset.

Lock column widths

After configuring column widths, you can lock them to prevent users from modifying the column sizes.

To lock column widths:

1. Adjust the column widths as required.

2. Select the Lock icon.

When column widths are locked, all column and row resizing options become unavailable, including drag-to-resize functionality.

The options in the Auto Fit dropdown are also disabled and unavailable until the column widths are unlocked.

To enable resizing again, select PowerTable > Manage Columns and then select the Lock icon to unlock the widths.