# Sheet Setting - Columns

In the "Columns" tab, you can change the order of the columns in the sheet, and confirm and change the visibility of each column at once.

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

The "Columns" tab lists all columns that have been added to the sheet, including hidden columns. It is also possible to see which columns are filtered and which columns are sorted. In addition, you can also perform the following:

* Switch the visibilities of columns
* Change the order of columns
* Change the fixed or scrolling display of columns
* Change filters of columns
* Change settings of columns
* Group column headers

### Switch Column Visibility <a href="#switch-column-visibility" id="switch-column-visibility"></a>

To hide a column, follow these steps:

1. Click on the Show/Hide icon **\[A]** of the column you wish to hide. Or select "Hide" from the target column's menu **\[C]**.
2. The column will be hidden and its label will be grayed out.

To make the hidden column visible again, follow these steps:

1. Click on the Show/Hide icon **\[A]** of the column you wish to display. Or select "Show" from the target column's menu **\[C]**.
2. The column will become visible and the column label will appear in its normal text color.

To show or hide multiple columns at once, follow these steps:

1. Check the checkboxes of the columns you wish to show or hide.
2. Select "Show All" (or "Hide All") from the menu **\[D]** in the upper right corner of the screen.
3. All selected columns will be shown (or hidden).

### Change Order of Columns <a href="#change-order-of-columns" id="change-order-of-columns"></a>

To change the order of columns, follow these steps:

1. Select and drag the columns you wish to reorder.
2. If you drag between columns, a blue bar will appear as an insertion indicator.
3. Drop the column in the position you want the new column to appear.

### Fix or Enable Scroll of Columns <a href="#fix-column-scrolling" id="fix-column-scrolling"></a>

To make a column fixed for horizontal scrolling, follow these steps:

1. Select and drag the column you want to fix.
2. Drag it to the area above the thick gray line **\[E]** and drop it.

To make a column scrollable that is fixed against horizontal scrolling, follow these steps:

1. Select and drag the column you want to scroll.
2. Drag and drop to the area below the thick gray line **\[E]**.

### Change Column Filter Setting <a href="#change-filter-setting" id="change-filter-setting"></a>

To change the filter setting for a column, follow these steps:

1. Select "Filter" from the menu **\[C]** for the column for which you want to set the filter.
2. The filter setting dialog will appear and you can set the filter appropriately.

To temporarily disable a filter, follow these steps:

1. Click the filter icon **\[B]** in the column for which you want to disable the filter.
2. The filter icon will appear white and the filter will be disabled.
3. You can also click the icon again to return the filter to the enabled state.

### Change Column Setting <a href="#change-filter-setting" id="change-filter-setting"></a>

To change the settings of a column, follow these steps:

1. Select "Setting" from the menu **\[C]** for the column you wish to change setting.
2. The column setting dialog will appear and you can make changes to the settings.

{% hint style="info" %}
Any changes to filter settings or column settings for each column made within the Column List Display Setting dialog will not be applied until the "Apply" button is pressed.
{% endhint %}

### Group Column Headers <a href="#group-column-headers" id="group-column-headers"></a>

To group column headers and display them in a nested fashion, follow these steps:

1. Select the columns by clicking the checkboxes of the columns you wish to group.
2. Select "New Group Column" from the menu **\[D]** in the upper right corner of the screen.
3. In the dialog that appears, enter the label to be displayed in the group column header and press the OK button.

See "[Group Column Headers](/mashmatrix-sheet/functions_about_displaying_data/group_column_headers.md)" for more information on grouping column headers.


---

# 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.mashmatrix.com/mashmatrix-sheet/functions_about_books_sheets/change_sheet_setting/sheet-setting-columns.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.