Use Formulas in Table Cells

Use Formulas in Table Cells

Understand Basic Concepts of Dimensioning

 

Annotate Drawings > Tables > 

Use Formulas in Table Cells

Expand All Expand all collapsed sections. Collapse All Collapse all expanded sections.

Concept

Procedure

Quick Reference

To automatically fill cells with incremented data

1. Double-click inside a table cell.
2. Enter a numeric value; for example, 1 or 01/01/2000.
3. Press the down arrow and enter the next desired numeric value.
4. On the Text Formatting toolbar, click OK.

   To change the format of the cell data, right-click the cell. Select Data Format.

5. Select the cell or cells from which you want to increment data from.
6. Click the grip in the lower right corner of the cell or cells.

   To change AutoFill options, right-click the AutoFill grip in the bottom right-hand corner of the selected cell range and select one of the following options:

   • Fill Series. Finds a pattern in the range of selected cells and fills the selected cells with the subsequent cell format and value. If only 1 cell is selected from which to increment data, then the data will increment at a rate of 1 unit.
   • Fill Series Without Formatting. Follows the above guidelines without cell formatting.
   • Copy Cells. Copies the format and values for the selected cells.
   • Copy Cells Without Formatting. Follows the above guidelines without cell formatting.
   • Fill Formatting Only. Fills only cell formatting for the selected cells. Cell values are ignored.
7. Drag the grip through the cells you would like to automatically increment. A preview of the value for each cell will display to the right of the selected grip.