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.
‘Fit to header’ resizes the columns to fit the column header.
‘Fit to content’ resizes the columns to fit the column contents.
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.
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.
