# 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.

![](/files/f564d578c77e8c1764f82cfefa6e5cda1ce7b82c)

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.

![](/files/8b5163620d5af506cd012ab9b49fd292d1a38f77)

Autofit options

{% stepper %}
{% step %}

### Fit to Header

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

![](/files/3ca9315b3b4fa90029a39d87891c3a458a138443)

Fit to header
{% endstep %}

{% step %}

### Fit to Content

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

![](/files/4fc61f02cd9e1515ceb90bb98877ede768541f55)

Fit to content
{% endstep %}

{% step %}

### 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.

![](/files/8025681b81d229d0a80d949e5ddd34e825f93804)

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.

![](/files/a84d8821a99addc49caef1ca922897ea2ad9ad04)

Reset to initial values
{% endstep %}

{% step %}

### 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.

![](/files/545dfac7041abc42f910f0dd9eb1e4b1a38383a3)

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.

![](/files/81695abd0830d17cadd0b88530ce74256be43777)

Locked column width

![](/files/d80e7128797597f6cb8af2e3bb838696c4eb6a69)

Locked row and column width options

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

![](https://docs.powertable.com/~gitbook/image?url=https%3A%2F%2F1781349671-files.gitbook.io%2F~%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FKyXRCFh0c08ryiUFvyMV%252Fuploads%252FLuUepp05ffDD4JUbRMEa%252Fimage.png%3Falt%3Dmedia%26token%3Dbb2cec6d-2899-4f77-8ef0-47c3aa2c9f57\&width=768\&dpr=3\&quality=100\&sign=8a03c216\&sv=2)

Unlock column width options
{% endstep %}
{% endstepper %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.fabricplan.com/powertable-sheets/how-tos/manage-columns/change-column-widths.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.