The table automatically expands when you enter data in adjacent cells:
–To the right of the last column.
–To the bottom of the last row (if the totals row is disabled).
To use smart table auto-expansion, use one of the following methods:
–Enter data manually.
–Paste data from the clipboard.
–Perform an autocomplete action.
Features of table auto-expansion
–There should be no other data in the expansion area.
–New data must not overlap with other tables.