File menu

Recalculate

Recalculates all formulas in all worksheets, whether open or closed. This function can also be accessed from the context menu of the worksheet image (on the drawing): right-click (Windows) or Ctrl-click (Mac) on the worksheet, and select Recalculate.

Preferences

Opens the Worksheet Preferences dialog box. Header and Footer text fields and the Margin settings apply to printed worksheets only. Select Show Grid to display the worksheet gridlines. Select Show Tabs to print worksheet column and row headers. Select Auto-recalc to recalculate all worksheet arithmetic functions when cells are edited. Click Font to specify the worksheet default font and size.

Printer Setup

Opens the Printer Setup dialog box. This is the same as the standard Printer Setup dialog box; however, it only affects the printer information for the worksheet.

Print

Opens the Print dialog box, to print the current worksheet; this is the only way to print a worksheet unless the worksheet is included as a part of the drawing

Edit menu

Undo

Undoes the last worksheet change; execute the command multiple times to undo multiple actions

Redo

Reverses the last Undo command; execute the command multiple times to redo multiple undo actions

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

Clear Contents

Deletes the contents of the selected cells

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.

Delete Columns

Deletes the selected columns from the worksheet.

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

View menu

Database Headers

Toggles between displaying and hiding all worksheet database header rows

Grid Lines

Toggles between displaying and hiding grid lines between the rows and columns of the worksheet, in both the worksheet window and the worksheet image (on the drawing)

Zoom

Increases or decreases the zoom percentage by preset levels from 50% to 300%; the current zoom level displays in the worksheet title bar. Select a zoom level from the Worksheet menu, or roll the mouse wheel while holding Ctrl (Windows) or Option (Mac) to increase or decrease the zoom level by increments of 10% (regardless of the number of lines you assigned the mouse to scroll in the mouse setup).

This feature will not work properly if standard scrolling is disabled in the mouse setup. For example, if the mouse’s scrolling size is set to “none,” mouse zooming in the Vectorworks program is disabled. (The specific settings required for this feature depend on the type of mouse being used.)

Insert menu

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.

Columns

Inserts columns in the worksheet, to the left of the selected columns. The number inserted depends on how many columns in the worksheet are highlighted at the time the command is selected.

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

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

Function

Opens the Select Function dialog box; select a function to be inserted in the formula (see Entering Formulas in Worksheet Cells)

Criteria

Opens the Criteria dialog box; select search criteria to insert in a formula

Image Function

(Vectorworks Design Series required)

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

Format menu

Cells

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

Column Width

Opens the Column Width dialog box. Set the width value of selected cells in the specified units. Click Standard Width to use the default width. The width of multiple selected columns can be adjusted at one time.

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.