+ Reply to Thread
Results 1 to 4 of 4

Copy sheet to another worksheet and not loose formatting

  1. #1
    Registered User
    Join Date
    09-17-2012
    Location
    Islamabad, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    10

    Question Copy sheet to another worksheet and not loose formatting

    When I copy/move a sheet to another workbook, I loose all the formatting.
    Is there anyway to not to loose formatting while copying?
    Other data is preserved.
    Here is the first file.
    https://www.dropbox.com/s/zl6y1wlhrh...wglucose1.xlsx
    When I move its sheet to the other file, formatting is lost.
    Here is the second file.
    https://www.dropbox.com/s/e2r8ajx45b...20budget1.xlsx

    I have shared the both sheets. Please let me know what can I do to solve this issue.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Copy sheet to another worksheet and not loose formatting

    If you right click on the sheet tab and "Move or copy.." it should retain formatting. Same with Copy>Paste I cannot view sheets from dropbox. If you think the sheets would help, attach them here (Go Advanced> Manage Attachments)
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    09-17-2012
    Location
    Islamabad, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Copy sheet to another worksheet and not loose formatting

    Blood pressure tracker wglucose1.xlsxHome construction budget1.xlsx
    files are attached

  4. #4
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Copy sheet to another worksheet and not loose formatting

    Hi Ahmed,

    I think, attachments are .. from Microsoft Template site..
    and Templates are used for the same purpose.. what you are try by copy paste..

    You can save those templates in Templates folder.. and you can insert New Sheet.. and choose Those templates to work on..XLST

    when you have a complete sheet with all the name range + merge range + format.. you can easily use it as a new sheet..

    Lets us know.. if you are facing any issue.. in googling "How to use Templates .. "
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Loose Embedded Graph Values when copying sheet to new workbook
    By Henk Stander in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-11-2013, 07:58 AM
  2. Replies: 3
    Last Post: 09-08-2013, 06:38 PM
  3. Replies: 2
    Last Post: 06-11-2013, 03:54 PM
  4. Replies: 1
    Last Post: 04-27-2012, 10:42 AM
  5. Most efficient macro to loose any formulas on whole sheet
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2011, 04:08 PM

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