Column Size in Grids

Column width can be easily changed by applying a preset, or by customization. The options available for column sizing are designed to meet a variety of formatting needs, including text wrapping for column and row headers. These tools give you flexibility and control over the look of your grid and ensure legibility.

Column size formatting can be set for matrix grids, tabular grids, and raw results grids, although not all functionality is available in all cases.

Changing Column Widths on the Canvas

Single Column Width

For all Grids, column widths may be increased or decreased on the canvas. Hover over the border of the column header until the cursor appears as a double arrow (purple highlight below), then click and drag your cursor to the left to shrink the column, or to the right to enlarge it.

Multiple Column Widths

You can also use the preceding functionality to resize multiple columns in one action:

Select multiple columns by Ctrl+clicking the column headers.
Click and drag your cursor to the left to shrink the columns, or to the right (purple arrow) to enlarge them.

The change applies evenly to all of the selected columns:

Combined Row Width

In Matrix Grids, you can also customize the combined row width; that is, the width of the row headers in combination. This is useful if you have a large grid containing several row header columns, and you want to ensure all columns are visible.

To customize the combined row width, hover your cursor over the border between the right-most row header and the left-most data column. A double-headed arrow appears (purple arrow below); drag the arrow to increase or decrease the total row header width.

Note: Depending on your grid row settings, a scroll bar may appear at the bottom of the grid (green arrow below).

Column Sizing Menu Options

The Column Sizing drop-down features several preset options that determine the width of the grid's columns, and whether the column or row width should continue to be customizable. This drop-down can be found in the Formatting panel and the Component ribbon.

Formatting Panel

The Column Size drop-down is located on the Settings tab of the Formatting panel for Matrix Grids, Tabular Grids, or Raw Grids. For a description of each of the Column Size preset options, see below.

Component Ribbon

Open the Column Sizing drop-down from the Component ribbon and select the required preset option. Alternatively, select Custom to customize column widths. For a description of each of the Column Size preset options, see below.

Note: The preceding example shows the Column sizing for a Matrix Grid. For Tabular or Raw Grids, Columns, Rows, and Data options are replaced by Measures.