Retaining Formatting rules in Table

**JyothiGrace** · 09-10-2021, 08:20 AM

Is there a way to retain cell formatting rules to newly added columns/rows in a table?

I scoured the internet but don't think there is a solution or workaround........

**TMS** · 09-10-2021, 08:30 AM

Unless you have manually adjusted the formatting of the cell(s)/row(s)/column(s), a Structured Table will normally replicate formatting in new rows. I usually find that selecting all the cells in the table and clearing all the formatting will then revert to the basic table formatting. Then apply your required formatting consistently to full columns.

**josephteh** · 09-10-2021, 10:22 AM

Table or no table, the added column formatting always follows the formatting of the column on the left, and the added row formatting always follows the formatting of the row on top.

**JyothiGrace** · 09-10-2021, 11:01 AM

It seems to work when adding rows but not columns....see attached

**TMS** · 09-10-2021, 11:29 AM

If you create a basic Table, it will, typically, have an alternating stripe pattern. If you format the first row manually, it will replicate the formatting when you add rows. If you add a column, there is nothing for Excel to base its replication on. So, you would have to select all the entries in the new column and format them as required. Then, when you add new rows, the format in the new column will be replicated.