EXCEL 365

Hi,

I have a Table in a Worksheet which has few protected cells on each row. When this Worksheet is protected and the last row of the table is reached, the system does not allow the expansion/addition of another empty row.

How do I overcome this problem, especially this worksheet must be protected against misuse of cells containing formulas.

Thank you

Saad