Table formatting does not extend when new table rows are auto-created (Excel 2016)

All,


I have an Excel table that automatically extends downward when data is entered immediately below the table. However, the table formatting is not applied to the new row(s). The new table rows essentially have default formatting.

I'm attaching a "Before" worksheet that shows the table in its original state, and an "After' worksheet that shows the extended table with the unformatted new row.

Could someone help me revise the "Before" worksheet so that the formatting continues as the table extends?

Thanks,

Jay

You can use format painter to copy the formats to next cells.