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

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Losing formatting when copying/pasting a worksheet (Excel XP)

    Author
    Topic
    #374050

    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!)

    Viewing 0 reply threads
    Author
    Replies
    • #603663

      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

      • #603675

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

    Viewing 0 reply threads
    Reply To: Losing formatting when copying/pasting a worksheet (Excel XP)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: