+ Reply to Thread
Results 1 to 5 of 5

Carrying formatting automatically to new W/S

  1. #1
    Jonah
    Guest

    Carrying formatting automatically to new W/S

    <!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.&nbsp; For example the original has some <b>emboldened</b>
    text, but on the copied sheet the emboldening has been lost.
    <p>Jonah</html>


  2. #2
    Ragdyer
    Guest

    Re: Carrying formatting automatically to new W/S

    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" <js_ss@REMOVETHIShotmail.com> wrote in message
    news:431B2510.5293B7B@REMOVETHIShotmail.com...
    > 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
    >



  3. #3
    Jonah
    Guest

    Re: Carrying formatting automatically to new W/S

    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" <js_ss@REMOVETHIShotmail.com> wrote in message
    > news:431B2510.5293B7B@REMOVETHIShotmail.com...
    > > 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
    > >



  4. #4
    Ragdyer
    Guest

    Re: Carrying formatting automatically to new W/S

    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" <js_ss@REMOVETHIShotmail.com> wrote in message
    news:431B3626.93A572E0@REMOVETHIShotmail.com...
    > 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" <js_ss@REMOVETHIShotmail.com> wrote in message
    > > news:431B2510.5293B7B@REMOVETHIShotmail.com...
    > > > 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
    > > >

    >



  5. #5
    Jonah
    Guest

    Re: Carrying formatting automatically to new W/S

    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" <js_ss@REMOVETHIShotmail.com> wrote in message
    > news:431B3626.93A572E0@REMOVETHIShotmail.com...
    > > 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" <js_ss@REMOVETHIShotmail.com> wrote in message
    > > > news:431B2510.5293B7B@REMOVETHIShotmail.com...
    > > > > 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
    > > > >

    > >



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1