Jul 24 2020 06:32 AM
I am trying to copy a row by using the format painter and when I click the row I want to change the format, nothing happens. I had this issue a few weeks ago and can't remember exactly how I fixed it. It had something to do with saving as a certain type, but there should be an easier way to fix this. Please help. I do majority of my work through excel and its inconvenient and delays my workload.
Jul 24 2020 08:48 AM
Jul 24 2020 08:50 AM
Hi @Sapphire87 ,
Just to be clear, Format Painter will no copy any data. Really just the text format of whatever you select.
Say you like the text format of cell A1 and want to replicate the exact same in cell B1 you would do the following:
Doing so will not copy the data from A1 to B1, only the text format.
Jul 24 2020 08:55 AM