Duplicating an already formatted Excel 2003 File ?


  1. Posts : 140
    Windows 7 Home Premium x64
       #1

    Duplicating an already formatted Excel 2003 File ?


    I have an EXCEL 2003 s/s setup in WIN 7.

    This contains data in 4/5 columns consisting of details of expenses incurred by two people who jointly own a boat and wish to share the costs equally .

    I have achieved this for the year 2011 and would like to create an identical s/s for 2012.

    Due to the fact that I am not familiar with EXCEL , I would like to start the new s/s with the same column setup , totals formulae and the header setup as I have already obtained for the year just ended without the hassle of setting up the same settings again.

    Would it be possible to just copy the 2011 s/s to the Clipboard and then paste it into my Excel App thus duplicating everything which I could then amend by deleting the old data before filling in the 2012 data ?

    Will this work ?
      My Computer


  2. Posts : 1,030
    Linux Mint / XP / Win7 Home, Pro, Ultimate / Win8.1 / Win10
       #2

    Couple of ideas for you...


    • Copy the file (as in File > Save As with a new name); update date formats in the new file.
    • Create a new worksheet in the current (2011) file and name it 2012, then copy all of the 2011 worksheet and paste to new 2012 worksheet; update date formats.


    Regards,
    GEWB
      My Computer


  3. Posts : 12,012
    Windows 7 Home Premium SP1, 64-bit
       #3

    Here's another idea:

    Continue using the same tab in the same spreadsheet--just add the 2012 dates as necessary.

    I've got a large and complex (80 tab) Excel file with various dates all over it, dating from 2003 to 2012.

    In a few cases, I have made a new tab for the new year, but generally I don't. As GEWB suggested, formulas are easily transferred to an adjacent tab if needed.

    Create a new tab (spreadsheet in the same file). Then poke the upperleftmost corner of the 2011 tab, to the left of column A and above row 1. That will select the entire sheet. Then right click and select copy. Then go to your newly created tab and select cell A1. Then paste.
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 03:28.
Find Us