How can we help you?

Formulas with structured references are entered as usual.

To specify the name of a table in a formula, proceed with the following:

1.Start typing the table name. A drop-down list will show the names of all tables that are contained in the document.

2.Select the name of the desired table using the mouse or the keyboard in one of the following ways:

Left-click the table name.

Select the table name using the ↓ and ↑ keys and press Enter.

The table name will be entered into the formula.

To enter the column name or a reference to the table area (for example, #Totals or @), do the following:

1.Enter the [ (left square bracket) symbol. The drop-down list will display the column names and the references to the table areas.

2.Select the desired element from the list using the mouse or the keyboard:

Left-click the element line.

Select the element line with the ↓ and ↑ keys and press Enter.

The selected element will be added to the formula.

If the reference to the table data area (for example, [#Headers]) is entered correctly into a formula, it is highlighted in color, and the table highlights the range to which it refers (in this example, the header row).

 

Was this helpful?
Yes
No
Previous
Structured reference syntax