Carrying formatting automatically to new W/S

J

Jonah

When I copy a workbook I want to be able to maintain the formatting and layout.

Whenever I have done this, the new worksheet always loses the formatting from the original.  For example the original has some emboldened text, but on the copied sheet the emboldening has been lost.

Jonah
 
R

Ragdyer

Right click on the sheet tab(s),
Select "Move or Copy",
Click on "Create a Copy",
Expand the "To Book" box and click on "New Book",
Then <OK>.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
Jonah said:
When I copy a workbook I want to be able to maintain the formatting and layout.
Whenever I have done this, the new worksheet always loses the formatting
Click to expand...
from the original. For example the original has some emboldened text, but
on the copied sheet the emboldening has been lost.
 
J

Jonah

Sorry about this, but it is not a new W/B but a new worksheet I needed. I also
tried what you said and I still get no formatting carried over.

J
 
R

Ragdyer

Might there be some underlying code in the sheet?

This procedure copies a sheet *exactly*, whether the original is protected
or not, whether it's saved or not ... it just works!

Describe exactly what you did, and where you did it.
 
Top