Columns

Note:
The default column layout and sort order is defined using the List Manager window. See Create and Manage Lists for further information.

Resize

To resize a column, click and hold on the line between columns and drag the line left or right to make it wider or narrower. Double-clicking on the line will resize the column to fit the largest string of text within that column.

Change Column Order

To change the order that columns are displayed in from left to right, click and hold a column header and drag it to a new position between two other columns. Two vertical arrows are displayed to assist the user in positioning the column.

Combine Columns

Data from multiple columns may be combined into a single column. Click and hold a column header and drag it to on top of the header of the column with which it is to be combined. Two horizontal arrows are displayed to assist the user in positioning the column.

The columns are then combined. For example:

Sort a List

The user can set the records in a list to be sorted according to the values in a selected column by clicking the heading of that column. By default, the sort order is lowest value to highest (for example, A to Z, low number to high number). This can be reversed by clicking the column heading again.

The selected column and the sort order is indicated by an arrow in the column heading. An arrow pointing upwards indicates the sort order is lowest to highest. An arrow pointing downwards indicates the sort order is highest to lowest.

To sort by multiple fields hold the <Shift> key while making selections. The list will be sorted in the order in which each column is selected.

This facility is enabled by default for a list. To enable this facility if it has been disabled, right-click on a column and select the Column Sorting option from the menu that is then displayed.

Pin Columns

When a column is pinned, it automatically becomes the first (left-hand most) column of the list, and remains displayed at the left-hand side of the list even when the list is scrolled to the right, so that it is always in view.

Pin icons are displayed in headings of a list. To pin a column, click on its pin icon.

When a column is pinned, its pin icon changes orientation, so that its point is downwards.

Click the icon again to unpin the column.

Column Summaries

The total of values in a column containing numbers can be calculated and displayed beneath the column.

Sum icons are then displayed in headings of a list if the summarize columns facility is turned on for that list. If not, to activate the facility for the current list, either check the Column Summaries checkbox in the Grid Options group of the View tab, or right-click on a column and select the Column Summaries option from the menu that is then displayed.

To display the total for a column click on the icon.

The selected total is then displayed beneath the column. For example:

Show Units in Column Headings

If the units of values in a list are to be displayed in the column headings, check the Show Units in Column Headers checkbox in the Grid Options group of the View tab.

Change Units

The units of measurement used to quantify values in a column may be changed if required.

To change the units for a column, click the button in the column heading, and select the required units from the list that is then displayed.

The values in the column are then recalculated in accordance with the new unit of measurement.

Auto-Size Columns

To auto-size columns so that each column in a list is wide enough to fully display the longest string of text, click Auto Size Columns in the Grid Actions group of the Home tab.