move or copy sheets doesn't copy format

  • Thread starter Thread starter ColinX
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Series fill only copying and fill series greyed out 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Can't Copy and Paste in Excel 2003 0
Making a Sheet copy 3
Move Worksheet to other File 1
Alt codes 4
Freeze Panes loss 3

Back
Top