Excel table formatting best practices question

Hello Jerry1385,

The fonts, cell colors, shading of rows, etc... all depend on the Table style that you initially choose. These styles should follow the same pattern for each row that is added to the table (whether the additional data is at the top or bottom). If changes are made to a cell but not the table style, then this pattern will not continue with rows that are added. Take for example the following:

Normal Table:

Adding rows below table retains table format:

Adding rows above retains table format:

I hope this is what you were looking for. If not, please do not hesitate to ask and I will try to explain in more detail.