Spreadsheet

Converts a database header row into a row of spreadsheet cells. This deletes all sub-rows and the information contained within them. Any formulas that were defined in the columns of the header row remain intact. This command has no effect on spreadsheet cells.

Database

Converts a row of spreadsheet cells into a database header row and opens the Criteria dialog box. This command has no effect on database rows.

Set Criteria

Opens the Criteria dialog box for setting the criteria that is used to generate the database sub-rows. Available only when a database header row is clicked.

Edit Criteria

Opens the Criteria dialog box for editing the criteria that is used to generate the database sub-rows. Available only when a database header row is clicked.

Select Data Items

Selects all objects on the drawing that meet the criteria for the database row. Available only when a database header row is clicked.

Format Cells

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

Row Height

Opens the Row Height dialog box; set the row height to automatically fit the selected cell contents, or set a specific row height in the specified units. The height of multiple selected rows can be adjusted at one time.

Insert Rows

Inserts rows in the worksheet, above the selected rows. The number inserted depends on how many rows in the worksheet are highlighted at the time the command is selected.

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

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

Delete Rows

Deletes the selected rows from the worksheet.

Use caution when deleting a row. Deleting cells that are part of a formula may change the values returned by the formula.

Clear Row Contents

Deletes the contents of the selected cells

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