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
thenoo

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
GEWB

Several flavors of Linux (Mint primary) / 32bit XP, Win7 HomeP / 64bit Win7 Pro, Ultimate / 64Win8.1
 
 

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 System SpecsSystem Spec
13 Feb 2012   #3
ignatzatsonic

Microsoft Community Contributor Award Recipient

Windows 7 Home Premium SP1, 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
.

Reply

 Duplicating an already formatted Excel 2003 File ?




Thread Tools




Similar help and support threads
Thread Forum
Excel 2003 file disappears in Windows 7
There is only one of my Excel 2003 files that almost disappears when I copy it over into my Windows 7 laptop and try to read it with either explorer or search for it, although it asks me to replace it everytime. It appears as if it doesn't exist. However when I open Excel 2010 and list only the...
Microsoft Office
Excel 2003 s/s AutoSum not responding
I have been entering data into Excel 2003 s/s with column B containing currency amounts using the AutoSum formula to get running totals as each row is entered. This has been adding the totals OK until the present cell B67. Suddenly the AutoSum has stopped adding additional entries. If I click on...
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Excel 2003 quits
When I change the formatting on a spreadsheet, ie. portrait to landscape, regular to bold font, etc, and try to save the file, I get an dialog box that says that Excel 2003 has quit, Windows 7 is trying to find out why, and I lose the editing done in that session. It happened 8+ times working on...
Microsoft Office
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office
Excel 2003 - Multiple Excel Open
Hi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it...
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 21:50.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App