

October 7, 2021

Hi,
This is the scenario:
- I add a number column (ColA) and format it as needed.
- I replace ColA with new Number column (ColB) and format it differently from ColA.
- I remove ColA.
- I re-add ColA. It lost its formatting, and now have either its original formatting, or ColB formatting.
How can I convince Excel to maintain ColA formatting?
Better yet, why Excel doesn't maintain columns' formatting from the original table?
Regards,
Ayal.

VIP

Trusted Members

December 7, 2016

Hello,
Don’t delete ColA is a good start to retain the formatting made for that specific column. You will get the same result if you remove other formatted columns and later add new columns bearing same header names. For Excel these table columns you add are new and will format them as per defined table style.
Br,
Anders


October 7, 2021

Dear Anders,
I cannot avoid deleting ColA.
Scenario for example: when analysing data with many columns, you want to put ColA next to ColB on a chart, then see relations between ColA and ColC, and then see relations between ColB and ColC.
I probably don't understand the 2nd part of your reply, since I don't change the headers of the columns at any point.
Regards,
Ayal.


Trusted Members
Moderators

November 1, 2018


VIP

Trusted Members

December 7, 2016

1 Guest(s)
