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