Cut

Removes the contents of selected cells, temporarily storing the contents in the clipboard

Copy

Copies the contents of selected cells to the clipboard, where they are temporarily stored; the original contents remain in the worksheet

Paste

Places cell contents stored in the clipboard into the current cell or range of cells

Format Cells

Opens the Format Cells dialog box, for setting the format and appearance of selected cells; see Formatting Worksheet Cells

Insert Image Function

(Design Series required)

Inserts the image function in the formula for the current cell; see Inserting Images in Worksheets

Insert

Inserts rows or columns in the worksheet. The number inserted depends on how many rows or columns in the worksheet are highlighted at the time the command is selected. Select Insert > Rows to insert above the selected rows. Select Insert > Columns to insert to the left of the selected columns.

Use caution when inserting rows or columns. Depending on the type of cell references used in formulas, inserting rows or columns could change the values returned by a formula.

To add rows to the bottom or columns to the right side of the worksheet, click and drag the bottom right corner of the worksheet.

Delete

Deletes rows or columns from the worksheet. Select one or more rows or columns and select Delete > Rows or Delete > Columns.

Use caution when deleting a row or column. Deleting cells that are part of a formula may change the values returned by the formula. Select Edit > Undo to undo the action.

Clear Contents

Deletes the contents of the selected cells

Pick Value from List

(Design Series required)

If the cell is in a database sub-row, and the column lists a field that only allows certain pre-defined values, use this option to edit the object’s data.

For example, you might want to change the sill style for several window objects from the window schedule. Select the Sill cells for the objects to be changed, and right-click (Windows) or Ctrl-click (Mac). Select a different sill type from the list of options to change both the worksheet and the objects’ data records.