Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Location
    Canada
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Losing formatting when copying/pasting a worksheet (Excel XP)

    When I copy and paste the entire contents of an Excel worksheet into a new spreadsheet, I lose most (not all) of the formatting. The cell widths aren't carried over, nor is most of the character formatting - font sizes, bolding, etc.

    Help! How can I copy and paste so that all the original formatting is retained? I tried Paste Special>All, but that didn't work :-(

    Thanks,
    Julia (admittedly not a power user!)

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Losing formatting when copying/pasting a worksheet (Excel XP)

    I do not have Excel XP.
    In Excel 97, I use the Edit / Move or Copy Sheet method. It might work in your version too.
    It gets all formatting (including column widths)
    From the menu select Edit
    Select Move or Copy Sheet
    In the dialog box indicate the workbook you want it copied to (or select New)
    Be sure you put check mark in box for Create Copy
    Click OK button
    Then just rename the worksheet tab and erase the old data that you do not want.
    Good luck.

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  3. #3
    New Lounger
    Join Date
    Mar 2002
    Location
    Canada
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Losing formatting when copying/pasting a worksheet (Excel XP)

    Your solution did the trick! Thanks VERY much for your help.

Posting Permissions

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