Change Column Widths

There are several ways to quickly change the width of columns, particularly when your table has a large number of columns.

The simplest way is to hover over the column header that needs to be resized and drag the handle to the desired size.

There are other preset and manual column width adjustment options available from the toolbar.

1. ‘Fit to header’ resizes the columns to fit the column header.

2. ‘Fit to content’ resizes the columns to fit the column contents.

3. The 'Manage Columns' menu allows you to manually specify the width for all columns in pixels.

Let's explore each of them with an example.

In the 'Home' tab, click on the 'Auto fit' icon as highlighted. You can see the options in the dropdown.

1. Fit to Header

Clicking on the Fit to Header option resizes each column to fit its column header.

2. Fit to Content

Clicking on the Fit to Content option resizes each column to fit its content.

3. Manage Column Width Manually

Click on Manage Columns. This menu allows you to enter the width for specific columns in pixels.

Enter the column width in pixels for the columns that you want to adjust.

You can use the Reset option to restore the column widths to their original values before any changes were made.

4. Lock column width

After you have adjusted the column widths as desired, you can lock the set column sizes to prevent users from changing them intentionally or unintentionally.

Click on the lock icon as shown below.

When the columns are locked, all options for adjusting column and row width are greyed out and unavailable, including the drag and adjust option.

To unlock and enable the column (and row) adjustments, click on Manage Columns and the lock icon again.