Formula Bar Display Explanation The cell address displays, and the red X and green check mark are active The cell is in a spreadsheet row or database header row. Edit the text, numbers, or formula from the Formula bar, or double-click the cell and edit the contents directly. To accept the edits, do one of the following: ● Click the green check mark ● Press Tab ● Press Enter (Windows) or Return (Mac) To cancel the edits, press Esc or click the red X. No cell address displays; the current cell value is not editable In database sub-rows, the results of calculations cannot be edited. In addition, object attribute information, such as the class the object belongs to, cannot be edited in the worksheet.
Edit the text, numbers, or formula from the Formula bar, or double-click the cell and edit the contents directly. To accept the edits, do one of the following: Click the green check mark Press Tab Press Enter (Windows) or Return (Mac) To cancel the edits, press Esc or click the red X.
No cell address displays, and the red X and green check mark are active (Design Series required) In database sub-rows, if Vectorworks Design Series products are installed, information that comes from the object’s data record can be edited in the worksheet, and the object’s record is updated automatically. For example, the price data for a sub-row object could be updated. Edit the data from the Formula bar, or double-click the cell and edit the data directly. To accept the edits and change both the worksheet and record, do one of the following: ● Click the green check mark ● Select another cell ● Press Tab ● Press Enter (Windows) or Return (Mac) To cancel the edits, press Esc or click the red X.
No cell address displays; a list of the values that are available for the current cell displays (Design Series required) In database sub-rows, if Vectorworks Design Series products are installed, some fields that come from the object’s data record can be edited, but they only allow certain pre-defined values. For example, the sill style for a window sub-row object could be changed. From either the Formula bar or the cell, select the new value from the list to change both the worksheet and record. Neither a cell address nor a cell value displays In database sub-rows, if the Vectorworks Architect or Vectorworks Landmark product is not installed, information that comes from the object’s data record cannot be edited in the worksheet. To edit a value that displays in a sub-row, right-click the number of the row that is associated with the item in the drawing, and select the Select Item command from the context menu.
Then use the Data tab of the Object Info palette to edit the object data. Resizing Rows and Columns To adjust column width or row height, drag the divider bar between the column letters or row numbers. If you select multiple rows or columns before you drag the bar, all rows or columns are adjusted to the same size. Alternatively, select the Column Width command from either the Format menu or the column context menu (see ). Adjust the row height with the Row Height command from either the Format menu or the row context menu (see ).
Text that is longer than the width of a cell “floats” over empty adjacent cells. Numbers that exceed the cell width are displayed with # characters. Alternatively, text can be set to wrap (see ). To hide a row or column, set the Column Width or Row Height to 0. To display the column or row again, position the cursor over the column letter or row number adjacent to the hidden column or row. When the cursor changes to a double bar resize cursor, click-drag the bar to resize the column or row. Cutting, Copying, and Pasting Cell Contents The standard shortcut keys for Cut and Paste can be used for worksheet editing.
The same value or formula can be copied and pasted to a range of cells. To copy cell contents to a cell or range of cells:. Select the cell with the information to repeat, and then press Ctrl+C (Windows) or Command+C (Mac) to copy the cell. Alternatively, select the Copy command from either the Edit menu or the appropriate context menu (see ).
Select the destination cell for the information, and then press Ctrl+V (Windows) or Command+V (Mac) to paste. The formula or value is repeated in each of the selected cells. Alternatively, select the Paste command from either the Edit menu or the appropriate context menu (see ). Adding Rows and Columns From the Insert menu, you can insert rows and columns (see ). An empty row is added above the current row, or an empty column is added to the left of the current column.
Another option is to position the cursor at the bottom right corner of the worksheet to activate a special resize cursor; drag to add rows and columns to the bottom and right side of the worksheet. Moving Rows and Columns Use the drag and drop method to move contiguous rows and columns or to move a copy of contiguous rows and columns. To move a copy of rows or columns:.
Click the column letter or row number to select a column or row (click-drag across the letters or numbers to select multiple columns or rows). Press and hold Ctrl (Windows) or Option (Mac) and move the cursor to the edge of the selected rows or columns. When the cursor changes to a copy cursor to indicate that moving a copy is permitted, drag the selection to the desired location in the worksheet. To move rows or columns:. Click the column letter or row number to select a column or row (click-drag across the letters or numbers to select multiple columns or rows). Move the cursor to the edge of the selected rows or columns.
When the cursor changes to a move cursor to indicate that moving the rows or columns is permitted, drag the selection to the desired location in the worksheet.
If the formula already exists in a cell you can fill it down as follows:. Select the cell containing the formula and press CTRL+ SHIFT+ DOWN to select the rest of the column ( CTRL+ SHIFT+ END to select up to the last row where there is data). Fill down by pressing CTRL+ D.
![Numbers Mac How To Edit Formula For Entire Column (-excel) Numbers Mac How To Edit Formula For Entire Column (-excel)](https://cdn.ablebits.com/_img-blog/copy-formula/fill-formula-entire-column.png)
Use CTRL+ UP to return up On Mac, use CMD instead of CTRL. An alternative if the formula is in the first cell of a column:.
Select the entire column by clicking the column header or selecting any cell in the column and pressing CTRL+ SPACE. Fill down by pressing CTRL+ D.