Extend table formatting in new rows?

It sounds to me that you have manually formatted in such a way that the formatting in other areas of the table have been affected. I have managed to do this by putting a double border around a column in the table after formatting with All Borders and other formatting and some of the other formatting that I had done either disappeared or was changed in an unwanted manner. All borders was one of the things that just disappeared in new rows.

Is this what you are experiencing?

My experiment was quite weird in that even the double border around the column got a bit corrupted in the process. I left the top border off the column formatting and the next row flipped the formatting so that the bottom border was missing!

This is quite the surprise for me as I have only removed formatting from tables.

I wouldn't bother much with formatting a table with "raw data" that has regular inputs. If a report is necessary, then copy the raw data to another location and format to suit your presentation. If you are looking for a fancy input, look into the creation of a user form.

If it is really necessary to have the table with special formatting, try on a copy to record a macro that would wipe out the existing formatting and create new formatting as needed.

If you upload your workbook, perhaps I can see what you are trying to do to make you data more easily read. Right now, I'm only guessing.

Upon opening your workbook, I immediately saw that you were encountering the same problems that I encountered with my experiments. The manual formatting of the columns (individually) caused a lot of problems. I first selected the whole table and applied the borders for the exterior and interior....the solid light line both for the interior and the left, right and bottom and a heavier line for the top. This solved some of the problem. I then selected up to and including column H within the table and applied the double border line to the right border while keeping the other formatting. Another thing that interfered with the table was the manual formatting of the background for the rows. I deleted that and also deleted the formatting in the rest of the worksheet.

As far as I can see, the table now acts like it should. New rows get alternately coloured and the borders retain their formatting.

What do you think of the result?

You're welcome. Thank you for the feedback.

To get rid of the horizontal formatting of the rows, I selected the rows and clicked on the background color button and chose No Fill.

To get rid of the formatting in the rest of the worksheet, I clicked in the row under table and selected the whole row, then Ctrl + Shift +Down Arrow. This selected all the cells below the table. Then on the Home tab, I clicked on Clear, then Formats.

That was it.

You're welcome.