How do I make Excel Tables auto‑expand when adding data below the last row or to the right of the last column?

Hi all,

I’m trying to ensure an Excel Table (ListObject) reliably auto‑expands in two cases:

1. when I add/paste data just below the last row, and
2. when I add a new header to the right (i.e., a new column).

Since some days the table doesn’t expand and the data stays outside the table range.

Thanks for your help.