Automatic table expansion

Table is automatically expanded when you enter data into adjacent cells in the column to the right of the table. If the table does not have a row of totals, auto-expansion is also performed when entering data into adjacent cells located in the row following the last row of the table.

You can enter data in the following ways:

• Manually. If you enter a formula in an adjacent column, that column becomes a calculated one.
• From the clipboard. The automatic expansion is performed if data is inserted into adjacent cells to the right/bottom of the table or inserted into both the table and adjacent cells at the same time.
• By means of cell autofill, when one or more cells of the table are selected as a reference cell.

Automatic expansion is performed if:

• The auto-expansion area does not contain any data.
• The inserted data does not overlap with another table.
• When pasting into adjacent cells, the range pasted from the clipboard does not extend outside the bottom or right border of the table.

tip

• The current version of the application does not support the automatic expansion of tables when autofilling cells if a table cell with a structured reference is selected as a reference cell.