4.2.1 Creating a New Embedded Table
To create a new embedded table, follow these steps:

1. Click the 'New Object' button, and select 'Embedded Table'. The cursor changes to a cross.
2. Click and drag the cursor across the cells that you want to compose the table. The cells are highlighted as you drag across them.

When you release the cursor, the highlighted cells are converted into an embedded table. The top row of cells becomes the title row of the table, the second-to-top row becomes the column header row of the table, and any remaining rows of highlighted cells become the data rows of the table.
3. To edit a column header, double-click on the header and enter the desired text.
4. To edit a data cell, click in the cell and enter text directly. You can enter both numeric and non-numeric values. (See Changing the Column Type in an Embedded Table.)
Assume that you want to create a table of values to be used in a formula for some other table on the Worksheet. (Refer to What-If Analysis for such an application of the embedded table.) In the following example you will create an embedded table with three rows and three columns of data.

1. Create a new Worksheet by clicking on the 'New Worksheet' button.

2. Click on the 'New Object' button, and select the 'Embedded Table' option. The cursor changes to a cross.
3. Drag across the Worksheet to highlight five rows and three columns. When you release the mouse, the selected range of the empty grid cells becomes part of the new table called 'Query1'; the first row of the selected range becomes the header row, and the second row becomes the column header row.
4. All the cells of this newly created table are editable. Double-click on the 'col0' header cell. The cell switches to editing mode, and you can now type in the cell to change the text.

5. Change the column names for 'col0', 'col1' and 'col2' to 'A', 'B' and 'C', respectively.
6. Enter any numeric values in the nine data cells. Note that both numeric and non-numeric values can be entered in the table.

See Also
Adding or Removing a Row from an Embedded Table, to change the table length.
| << 4.2 Creating an Embedded Table | © 1996-2013 InetSoft Technology Corporation (v11.4) | 4.2.2 Converting a Regular Table to an Embedded Table >> |