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.

Drag column headers to resize

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

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.

Autofit options

1

Fit to Header

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

Fit to header

2

Fit to Content

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

Fit to 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.

Set column width manually in pixels

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

Reset to initial values

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.

Lock Column Widths

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

Locked column width

Locked row and column width options

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

Unlock column width options