Adding and Removing Columns

Another way you control what information appears on the screen is by customizing the spreadsheet to display only the columns you want. This feature is particularly useful when you want to display only specific columns for the operator, such as the recipe identifier, the calculated value and the override value.

You can customize the spreadsheet displayed in both windows by adding and removing only the specific columns you want. By selecting the Edit Display Formats command, you can add a column to or remove a column from the spreadsheet. This command also allows you to edit the text of each column heading and control whether the column is modifiable.

When you select Edit Display Formats from the Window menu, the Window Display Format dialog box appears. This dialog box has the following controls:

Available Columns list box — lists the columns you can add to the spreadsheet. If the list box is empty, all the available columns are in use.

Column Layout list box — lists the columns currently displayed in either the Recipe Operations window or the Recipe Development window. By default, the columns in the Recipe Development window appear. The list box displays the columns in the same order as they appear in the recipe and indicates which columns are modifiable.

The following table provides instructions for using the Window Display Format dialog box.

Window Display Format Procedures 

To...

Then...

Add a column to the spreadsheet.

1. From the Available Columns list box, select the column you want to add.

2. Select the Add button. The selected column appears in the Column Layout list box and disappears from the Available Columns list box.

If you prefer, you can add a column to the spreadsheet by double-clicking a column in the Available Columns list box.

Remove a column from the spreadsheet.

1. From the Column Format list box, select the column you want to remove.

2. Select the Delete button. The selected column disappears from the Column Layout list box and appears in the Available Columns list box.

Arrange a column in the spreadsheet.

1. In the Column Layout list box, select the column you want to move.

2. To move the column up in the list box and to the left in the recipe, select the up arrow button. To move the column down and to the right, select the down arrow button.

To display the columns from the Recipe Operations window.

Select the Switch to OP button. The columns from the Recipe Operations window appear in the Column Layout list box.

To display the columns from the Recipe Development window.

Select the Switch to DEV button. The columns from the Recipe Development window appear in the Column Layout list box.

See Also