Excel Table adding Rows does not keep formatting and Formulars

Question

while adding a new row to a table by just starting to type in the first available cell, the new row does not maintain the formatting of the rows above nor does it copy any formulas to the new row. It worked well in earlier versions but has stopped now. I could use the right-click menu with inserting a new row into the table, that does keep the formatting at least. but the formula isn't carried over at this time either.

is that a bug at Excel or with me? Running version 1804 via Microsoft Office 365

Thanks

Answer 1

Hi,

Go to File --> Options and follow the steps