Results 1 to 2 of 2
  1. #1
    Past Drink-by Date
    Join Date
    Dec 2004
    Crofton Downs, Wellington

    Default Excel: copying sheet formats from workbook to workbook

    I have an Excel workbook for generating GST information for those of my clients who don't use Xero online accounting. One of the worksheets in the workbook is a facsimile of the standard GST101 form, which is populated from the worksheets preceding it. The workbook replicates the layout, boxes, fonts etc of the original form, including the overall buff background. (Yes I know, it sounds like overkill, but it does help some clients recognise just where to enter their information in the actual form to be filed)

    When I copy this workbook to use for another GST period in Excel versions before 2010, all the formatting would stay unchanged in the new file. However, if I copy the worksheet to a new file or a different workbook in Excel 2010, the buff background format changes to a violent purple shade. Can anyone suggest how I can stop this unwanted change happening, or how to fix it?

  2. #2
    Senior Member
    Join Date
    Jan 2016

    Default Re: Excel: copying sheet formats from workbook to workbook

    I use Office 2016 however think it is similar to 2010.
    Open both the source workbook and the destination workbook (or just source workbook if creating a new workbook)
    Right Click the spreadsheet tab of the source workbook to be copied
    If "Move or Copy" is grayed out then you will need to Unprotect the Workbook and/or Spreadsheet. This is found under the "Review" tab in the menu. Also confirm the destination Workbook is unprotected.
    Click the "Move or Copy" as above.
    Select the "To book" and then select the destination workbook (or new as required)
    Click "Copy to Create" checkbox
    Then Click OK
    Hopefully this will work for you

Similar Threads

  1. Replies: 1
    Last Post: 14-08-2005, 05:45 PM
  2. No of Excel Sheets in a Workbook
    By Brain_Cell_Anon in forum PressF1
    Replies: 7
    Last Post: 01-12-2004, 12:48 AM
  3. Replies: 2
    Last Post: 05-05-2001, 06:03 PM
  4. Excel Protecting a Workbook
    By in forum PressF1
    Replies: 0
    Last Post: 12-10-1999, 01:00 AM
  5. No workbook sheet nrs
    By in forum PressF1
    Replies: 0
    Last Post: 10-07-1999, 01:24 PM

Posting Permissions

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