> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/documentation/readme/powertable-sheets/how-tos/manage-columns/change-column-widths.md).

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

   <figure><img src="/files/F9rvabjl5t2DUOUD8uQX" alt=""><figcaption></figcaption></figure>

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

   <figure><img src="/files/biscfGr8zAJgmEipxhT0" alt=""><figcaption></figcaption></figure>

#### Fit to header

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

<figure><img src="/files/kOFnT4P5hgFZU0ALgbOs" alt=""><figcaption></figcaption></figure>

#### Fit to content

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

<figure><img src="/files/ukuTlKzrBQY84JsSFiYe" alt=""><figcaption></figcaption></figure>

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

   <figure><img src="/files/I4iwNeuGrZXhKTcv5jYj" alt=""><figcaption></figcaption></figure>

To restore the original column widths, select **Reset**.

<figure><img src="/files/RDfvlt1HtnLT0qspDlLy" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/MPCHjWzMd8d7qyCmmoQh" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/BHtxiOzKTzoPFmHp3eCa" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/0dhT1koPHY8SvcdNFpjY" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

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

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.
