Adding, Moving, and Deleting Columns

You can add columns to the formula grid, delete columns from it, and change the order of columns. You can also pin columns to the left or the right side of the grid.

This task shows you how to:

See Also
Formula Grid Overview
Resizing Columns
Aligning Column Text and Renaming Columns
Special Column Types
Expanding and Collapsing All Rows
Formula Grid Columns Reference
Adding, Moving, and Deleting Rows
Undoing and Redoing Actions in the Formula Grid

Add a Column

  1. Move the mouse pointer over any column header, so that the tool becomes visible.
  2. Click , and then click in the panel that opens.
  3. In the list of columns, select the columns that you want to add.

    You can filter the list of columns by starting to type the name of a column in the Filter box above the list. For details of all available columns, see "Formula Grid Columns Reference."

    You can add all available columns by selecting the box to the left of the Filter box. Note that because many columns are available, this can make the grid very wide, in which case you can scroll the grid sideways to see all the columns.

    The columns that you select are added to the formula grid immediately as you select them.
  4. Click anywhere outside the list of columns to close the list.

Move a Column

With the mouse pointer, drag the header cell of a column horizontally to its new position in the grid.

Pin a Column

Context: You can pin a column to the left or the right side of the formula grid.

  1. Move the mouse pointer over the header of the column that you want to pin, so that the tool becomes visible.
  2. Click , and then click in the panel that opens.
  3. In the menu, select Pin Column > Pin Left or Pin Column > Pin Right.

    The column is pinned to the left or the right side of the formula grid.

    Note: When you pin a column to the left, the new pinned column is positioned after any existing left-pinned columns. When you pin a column to the right, the new pinned column is positioned before any existing right-pinned columns. You can move pinned columns relative to each other, as described in Move a Column.
    Note: To unpin a pinned column, select Pin Column > No Pin.

Delete a Column

  1. Move the mouse pointer over any column header, so that the tool becomes visible.
  2. Click , and then click in the panel that opens.
  3. In the list of columns, cancel the selections for the columns that you want to remove from the grid.

    You can filter the list of columns by starting to type the name of a column in the Filter box above the list. For details of all available columns, see "Formula Grid Columns Reference."

    The columns that you deselect are removed from the formula grid as you deselect them.
  4. Click anywhere outside the list of columns to close the list.