Duplicating an already formatted Excel 2003 File ?

[thenoo]

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 ?

 

[GEWB]

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

 

[ignatzatsonic]

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.