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........
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........
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.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
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.
It seems to work when adding rows but not columns....see attached
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.
Ok, maybe it does not work that way for added column in a table. One way to overcome it is to insert a column, then add the new column.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks