Carrying formatting automatically to new W/S

Jonah · 09-04-2005, 01:05 PM

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
When I copy a workbook I want to be able to maintain the formatting and
layout.
<p>Whenever I have done this, the new worksheet always loses the formatting
from the original.  For example the original has some <b>emboldened</b>
text, but on the copied sheet the emboldening has been lost.
<p>Jonah</html>

Ragdyer · 09-04-2005, 02:05 PM

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

Jonah · 09-04-2005, 02:05 PM

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

Ragdyer wrote:

> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >

Ragdyer · 09-04-2005, 08:05 PM

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.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jonah" <[email protected]> wrote in message
news:[email protected]...
> 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
>
> Ragdyer wrote:
>
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> > >
>

Jonah · 09-05-2005, 08:05 PM

Underlying code? Where do I look?

Jonah
-------------

Ragdyer wrote:

> 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.
> --
> Regards,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Jonah" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
> > Ragdyer wrote:
> >
> > > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > 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
> > > >
> >