The following operations with columns are available when working with sheets:
There are two ways to insert a column:
Insert to the Left. A new column is added to the left of the current one. The new column width is the same as the width of the column to the left of the current one.
Insert to the Right. A new column is added to the right of the current one. The new column width is the same as the width of the current one.
NOTE. Adding columns is not available if a new column is in the table area range.
To add a new column, select an existing column, or any cell in the column, and execute one of the following operations:
Select the Insert Column Left or Insert Row Right item in the column header's context menu.
Select the Insert > Insert Column Left or Insert > Insert Column Right item in the column cell's context menu.
Press ALT+T to insert a column left.
NOTE. If, before adding a column, filtering is set up for a range, it will also be applied for the new column.
The columns to the right of the new column are shifted one position to the right. When a column is inserted to the left, all the columns, starting from the selected one, are shifted. When a column is inserted to the right, the selected column stays in its place, and the columns to the right of it are shifted.
Multiple columns can be added at the same time. In this case, the number of inserted columns matches the number of initially selected columns.
There are several ways to change column width:
Manual resize. To manually resize column width, hover the cursor to the column's right border in the header area, click the border, hold down the cursor and drag it to the required distance. The actual column width is displayed in a tooltip.
Exact resize. To set exact size, select the Resize Column context menu item in the selected column or column header. In the dialog box that opens enter (or change) column width value in pixels or millimeters:
Quick row height fit. To quickly fit row or column size by contents, execute one of the operations:
Select the Fit Column Width item in the selected cell's or column header's context menu.
Select the View > Fit Column Width item in the selected cell's or column header's main menu.
Double-click the right border of the column header.
Each of these methods can be applied to a single column or a group of columns. The changed size is applied to each column in the group.
Column hiding can be used when columns contain intermediate results. The data stored in hidden columns is not shown in the screen or on a printed sheet.
To hide a column, select the column (or any cell contained in the column) and select the Hide item in the column header's context menu.
After executing one of these commands the selected column is hidden. The column at its right takes place of the hidden column.
Multiple columns can be hidden at the same time.
To unhide a column, select two columns: to the left and to the right of the hidden one, then select the Unhide item in the context menu of the selected columns headers.
After this, the hidden columns between the selected columns are shown.
If several hidden columns are located between the selected columns, all hidden columns are shown after selecting the Unhide item.
To delete a column, select an existing column, or any cell in the column, and execute one of the following operations:
Select the Delete Column item in the column header's context menu.
Select the Delete > Delete Columns item in the context menu of the cell contained in the column.
After executing this command the selected column is deleted, and all the columns to the right of it shift one position to the left.
Deleting columns is not available if the deleted range contains the cells included in the attribute or table areas.
To keep the leftmost column visible on scrolling report areas, freeze the column.
See also: