Insert Row formatting

[DocBrown]

Can someone tell me the 'rules' that Excel is using in this situation? And an
impossible question: why?

I have a table that has a header row with AutoFilters turned on. If I select
the row following the header and select Right-click insert. A row is inserted
above the current one, but the row inherits the formatting and other
attributes from the row above.

Why the heck is it inheriting from the row above but inserting above the
selected row. I would more expect the inserted row to inherit from the
selected row.

Second question. Most columns are not inheriting the borders, but three
columns are. What would cause some columns to inherit the borders but not
others?

Thanks a bunch,
John S.

 

[DocBrown]

A more important problem is that the header row is locked and the sheet
protected. So the inserted row inherits the locked status. How can I prevent
inheriting the lock?