Excel Table Auto Formatting Issue

LilYawney 

To change the auto-formatting of new rows in an Excel table, you can modify the formatting of the table itself.

Here is how you can do it:

1. Click anywhere inside the table to activate the "Table Tools" contextual tab in the ribbon.
2. In the "Table Styles" group, click the "More" button (the downward-facing arrow) at the right corner of the table styles gallery. This will open the "Table Styles" pane.
3. In the "Table Styles" pane, hover your mouse over different table styles to preview how they will look.
4. To apply a specific style to the table, click on the style you want. The table will change its appearance based on the selected style.
5. If none of the built-in styles match the desired look, you can customize the table format manually:

1. Click the "New Table Style" button at the bottom of the "Table Styles" pane (icon with a table and a plus sign). b. In the "New Table Style" dialog box, you can customize various formatting options like font, fill, border, etc. c. Give your custom style a name, and click "OK" to create the new table style.

1. Once you have the desired table style applied or created, any new rows you add to the table will inherit the formatting of that style.

If you want to make sure that the first row in your table is formatted the way you want, set up the desired formatting in the table, and then add the first row manually. After that, any new rows added below will automatically adopt the same formatting. The text and the steps are the result of various AI's put together.

My answers are voluntary and without guarantee!

I hope this helps!