15.5.7 Formatting Rows and Columns

When viewing and editing your input/output attributes, you can format the table to display only the attributes you want to see.

Note: Clicking the top-left cell selects all rows in the I/O Attribute Editor.

To hide one or more rows or columns:

  1. Select the row(s) or column(s) you want to hide from view.
  2. From the Format menu, choose Row > Hide or Column > Hide, or right-click the row or column header and choose Hide from the right-click menu.

To show a hidden row or column:

  1. Select a range of rows or columns that span one or more hidden rows or columns.
  2. From the menu, choose Row > Hide or Column > Hide, or right-click the row or column header and choose Unhide from the right-click menu.
Note: Unhide also works for a selected column that has a hidden column to its immediate left or right (or both).

You can “freeze” (or lock) one or more columns so they remain visible on the screen as you scroll horizontally.

To freeze or lock one or more columns:

  1. Select the column to the right of the last column to freeze.
  2. From the Format menu, choose Column > Freeze Pane, or right-click the column and choose Freeze Pane from the right-click menu.

To unfreeze one or more frozen columns, from the Format menu, choose Column > Unfreeze Pane, or right-click any column header and choose Unfreeze Pane from the right-click menu. All frozen columns are unfrozen.

You can also resize all the columns and rows at once so their entire contents are visible.

Note: You must unfreeze the current locked group before you can freeze another group.

To display a column's entire contents within it:

  1. Select the column(s) you want to display.
  2. From the Format menu, choose Column > AutoFit. The width of the column either expands or contracts to fit only the cell heading and cell contents.