The main Worksheet menu commands are described in the following table.
Worksheet Command |
Description |
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. |
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. |
|
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 |
Copies the contents of selected cells to the clipboard, where they are temporarily stored; the original contents remain in the worksheet |
|
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 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. |
Delete Columns |
Deletes the selected column(s) 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 |
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. |
Columns |
Adds columns to the worksheet, to the left of the selected column(s). 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. |
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 |
Format menu |
|
Cells |
Opens the Format Cells dialog box, for setting the format and appearance of selected cells |
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. |
|
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. |
~~~~~~~~~~~~~~~~~~~~~~~~~