Worksheet Row Context Menu

To access the commands available for a specific worksheet spreadsheet or database header row, right-click (Windows) or Ctrl-click (Mac) while on the row number. These commands do not apply to database sub-rows.

Menu Item
Description

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

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

Adds rows to the worksheet, above the selected row(s). 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.

Delete Rows

Deletes the selected row(s) 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

Database Sub-Row Context Menu

While on a database sub-row, right-click (Windows) or Ctrl-click (Mac) and select the Select Item command from the context menu. Use this command to select an individual database object in the drawing; the view changes to display the selected object (see Importing Worksheets). The command is unavailable if the sub-row is summarized (see Database Row Sort and Summary Functions).

~~~~~~~~~~~~~~~~~~~~~~~~~

Worksheet Menu

Worksheet Cell Context Menu

Worksheet Column Context Menu

 

www.vectorworks.net