Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Duplicating an already formatted Excel 2003 File ?

13 Feb 2012   #1

Windows 7 Home Premium x64
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 System SpecsSystem Spec

13 Feb 2012   #2

32bit: XP, Win7 H.P. / 64bit: 2008R2, Win7 Pro, Ultimate / Several flavors of Linux

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.

My System SpecsSystem Spec
13 Feb 2012   #3

Microsoft Community Contributor Award Recipient

Windows 7 SP1, Home Premium, 64-bit

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 System SpecsSystem Spec


 Duplicating an already formatted Excel 2003 File ?

Thread Tools

Similar help and support threads for2: Duplicating an already formatted Excel 2003 File ?
Thread Forum
Excel 2003 file disappears in Windows 7 Microsoft Office
Solved Excel 2003 s/s AutoSum not responding Microsoft Office
Formatting Excel 2010, Excel 2003 Microsoft Office
Excel 2003 quits Microsoft Office
Excel 2003 Macro Help? Microsoft Office
Can't open 2003 Excel Files in Excel 2007? Microsoft Office
Excel 2003 - Multiple Excel Open Microsoft Office

Our Sites

Site Links

About Us

Find 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 09:04 PM.
Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33