Rayne
asked on
Cell Fomrat - change and revert back to original format
Hello,
In cell F13 there is text. Now First I want that text to be merged ,wrap texted and spread over a number of cells. To do that, all I do is select F13:K16 and then press the button “Format Spread” and it does what it should. Now if I want to revert back all the changes and bring it back to the original, I press the button “ClearFormatAndRestore” – which unmerges the cells.
This button [ClearFormatAndRestore] seems to work - but with the exception that I am Not seeing the border color of individual cells returning to their original color state. It’s all white inside. I also indicated the desired at the bottom of the sheet as well.
Thanks
formatborder---Copy.xlsm
In cell F13 there is text. Now First I want that text to be merged ,wrap texted and spread over a number of cells. To do that, all I do is select F13:K16 and then press the button “Format Spread” and it does what it should. Now if I want to revert back all the changes and bring it back to the original, I press the button “ClearFormatAndRestore” – which unmerges the cells.
This button [ClearFormatAndRestore] seems to work - but with the exception that I am Not seeing the border color of individual cells returning to their original color state. It’s all white inside. I also indicated the desired at the bottom of the sheet as well.
Thanks
formatborder---Copy.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is great The Barman, thank you :)
Open in new window
should be
Open in new window