Work with the editing grid
- Last UpdatedApr 10, 2025
- 4 minute read
Recipe Manager includes a set of editing commands to add, modify, or delete data from the templates. Generally, you select the data that you want to edit in the template, and then take an editing action. The following table describes common features of recipe templates to enter and select template data.
|
Feature |
Description |
|---|---|
|
Input Box |
Text input box used to enter data for the selected template cell. When a template cell is selected, its contents are shown in the text input box near the top of the Recipe Manager dialog box. |
|
Select All Cells |
Select the top left cell of the template to select all cells.
|
|
Select All Rows |
Select on a template’s row name to select all cells within the row. |
|
Select All Columns |
Select on a template’s column heading to select all cells within the column. |
|
Auto-Size All Columns |
Double-click on a template to auto-size all columns in the template to the width of the longest entry. |
|
Auto-Size a Column |
Double-click on the heading to auto-size the column to the width of its longest entry. Note: The Item Type column in the Template Definition template cannot be auto-sized. |
When you edit a template, you can do the following:
-
Clear data from a range of cells.
-
Copy data from a range of cells to an adjacent range of selected cells.
-
Insert a row within the Template Definition template.
-
Insert a column within a template.
-
Delete a row from the Template Definition template.
-
Delete a column from a template.
Clear data from a range of cells
-
Select a range of cells from the template.

-
On the Edit menu, select Clear. A message appears requesting confirmation that the selected range of cells should be cleared.
-
Select Yes. The template clears data from the selected range of cells.
Copy a range of cells to an adjacent selected range
-
Select the cell or the range of cells to be copied.
-
Select the adjacent range of cells that you want to copy the data.

The selected ranges must be the same size and can be above, below, to the right, or to the left of the original range of selected cells.
-
On the Edit menu, select the appropriate fill command. The data is copied to the selected range of cells.
Note: If the new column that the data is copied to is not big enough to accommodate the largest entry, double-click on the column heading to change the width to the longest entry.
Insert a row in the Template Definition template
-
Select the Template Definition template.
-
Select the Item # to select the row in the Template Definition template to insert a new row above it.
You cannot directly insert rows in either the Recipe Definition or Unit Definition templates. Instead, all modifications to the Template Definition are automatically inherited by the Recipe Definition and Unit Definition templates.
-
On the Edit menu, select Insert. A new row is inserted immediately above the row you selected and all subsequent rows are automatically renumbered.

Note: If the maximum values configured for the Recipe Manager Preferences have been reached,
the Insert command is inactive. You must increase the numbers specified to add Items/Units/
Recipes to your recipe templates.
When you modify the Preferences, the changes are applied to all existing recipe template
files.
Insert a column
-
Select Unit # or Recipe # to select the column that will be to the right of the inserted column.
You can insert columns in the Recipe Definition or Unit Definition templates.
-
On the Edit menu, select Insert. A new column is inserted to the left of the selected column.

In this example, Mixer2 data is moved to the Unit 3 column and a new column inserted as Unit 2.
Delete a column
-
Select the Unit # or Recipe # column heading to select the column that you want to delete.
You can delete columns from the Recipe Definition or Unit Definition templates.
-
On the Edit menu, select Delete. A confirmation message dialog box appears asking you to confirm the deletion.
-
Select Yes. The column is deleted from the template and the remaining columns are renumbered.
Delete a row
-
Select the Template Definition template.
You can delete rows from the Template Definition template, but not the Recipe Definition or Unit Definition templates.
-
Select the Item # row header to select the row that you want to delete.
-
On the Edit menu, select Delete. A confirmation message dialog box appears asking you to confirm the deletion.
-
Select Yes. The row is deleted from the template.
