move or copy sheets doesn't copy format

C

ColinX

I tried the move or copy sheets option, but the formatting doesn't copy. I
have to highlight and paste the format. is there a solution or setting to
change? Excel 2002
 
G

Gord Dibben

Move or copy sheets does exactly what it says.

No formatting is lost or changed.

Assuming you are right-clicking on a sheet tab and "Move or Copy"

If using any other method, please let us know.


Gord Dibben MS Excel MVP
 
Top