On any sheet you can right-click the tab at the bottom of your desktop window and select "Copy Formatting". Then you can go to the target sheet, right click and select "paste formatting".
I find that this doesn't always preserve every formatting element -- especially if the shapes and dimension mixes differ from sheet to sheet. But it will grab what it can.
You mention different versions. I have no idea if this will work across versions. All you can do is give it a try and see.
I would like to copy/paste between two workbooks. This is not working. Kindly assist.
1 of 1 people found this helpful
It works between workbooks. I do it all the time.
But again, I don't know what to expect between versions, if you are doing it between workbooks that are different versions.
You may just have to re-format manually in the new workbook.