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 |
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).
~~~~~~~~~~~~~~~~~~~~~~~~~