+ Reply to Thread
Results 1 to 2 of 2

Copying content and formats to another worksheet

  1. #1
    Zach Mathew
    Guest

    Copying content and formats to another worksheet

    How do you copy an exact replica of a portion of one worksheet to another
    worksheet. I need the content and formatting (column and row widths, fonts
    colors, etc.) duplicated exactly. I've tried Edit/Paste Special but the
    column and row height settings don't copy over. Thanks.



  2. #2
    Max
    Guest

    Re: Copying content and formats to another worksheet

    Right-click on sheet tab > Move / Copy
    Check "Create a copy" > OK
    (This usually works for me)
    --
    Rgds
    Max
    xl 97
    ---
    GMT+8, 1 22' N 103 45' E
    xdemechanik <at>yahoo<dot>com
    ----
    "Zach Mathew" <zmathew@iccb.org> wrote in message
    news:uGCgI4sPFHA.2736@TK2MSFTNGP09.phx.gbl...
    > How do you copy an exact replica of a portion of one worksheet to another
    > worksheet. I need the content and formatting (column and row widths,

    fonts
    > colors, etc.) duplicated exactly. I've tried Edit/Paste Special but the
    > column and row height settings don't copy over. Thanks.
    >
    >




+ 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