move or copy sheets doesn't copy format
 

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

move or copy sheets doesn't copy format
 

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

On Wed, 14 May 2008 12:27:01 -0700, ColinX
wrote:

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