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.

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

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

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

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

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

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.

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.

Group Column Headers

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" for more information on grouping column headers.