Power Query
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
Power Query
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)