12-02-2009, 10:20 PM | #1 |
CEO of the Internet
|
Anyone talented with Excel?
working on a term project here for accounting, and i'm organizing all my different statements into new sheets within a workbook. for some reason, excel won't carry the header (where my name, student number, course number, etc. is all located) onto a new sheet.. just to make sure someone reads it right, this isn't a new page, i'm working with sheets here. new sheet within a workbook. soo, the question: to find out if Excel can carry headers over onto a new sheet. any chance someone here is an excel wizard?
__________________
|
12-02-2009, 10:29 PM | #2 |
E.B.A.H.
Drives: you wild... Join Date: Mar 2007
Location: In the happy padded room wearing a jacket that makes me hug myself...
Posts: 18,421
|
right click the tab, move to, check the "copy" box and it should duplicate the tab as is, formatting and all.
|
12-02-2009, 10:30 PM | #3 |
Drives: Corvette ZO6 CSR edition #47 Join Date: Apr 2009
Location: Calhoun, GA
Posts: 767
|
wife is you need me to wake her??
__________________
Nationwide Turf
"artificial turf factory" |
12-02-2009, 10:30 PM | #4 |
Booooosted.
|
You can go to 'Format' and then go to 'Move or copy sheet'
Move them with the header before you complete the sheet. If I'm understanding you correctly. |
12-02-2009, 10:33 PM | #5 |
Booooosted.
|
That's a lot quicker than mine to do the same thing. That's what I get for teaching myself. lol
|
12-02-2009, 10:33 PM | #6 |
36.58625, -121.7568
|
|
12-02-2009, 10:34 PM | #7 |
CEO of the Internet
|
attempting....
__________________
|
12-02-2009, 10:35 PM | #8 |
Booooosted.
|
|
12-02-2009, 10:39 PM | #9 |
CEO of the Internet
|
ohh... so if i've already completed the sheet, i'm SOL?
i suppose i could always make a new sheet then copy/paste my data into the new sheet.... and no need to wake the wife
__________________
|
12-02-2009, 10:42 PM | #10 |
Booooosted.
|
Maybe you could undo everything back to the header and then copy it and close without saving?
Then you could bring the original back up and have the copy of only the header? |
12-02-2009, 10:43 PM | #11 | |
PWA Relapse
|
Quote:
Then never close the open book that has the copy. Instant backup. - X
__________________
2017 1LT/RS A8 Hyper Blue Metallic |
|
12-02-2009, 10:48 PM | #12 | |
Booooosted.
|
Quote:
I must not be understanding what he's doing. Can't you just move the header? |
|
12-02-2009, 10:50 PM | #13 |
Booooosted.
|
Can you e-mail me the book? I could look at it for ya and I'd understand better?
|
12-02-2009, 10:52 PM | #14 |
Gearhead
Drives: MS3 Join Date: Nov 2008
Location: Canada
Posts: 27
|
PROBLEM SOLVED!!! EXCEL GEEK AND BRO FTW!
__________________
-sig by Moto-Camaro |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Gear Ratio/RPM/MPH Spreadsheet in MS Excel ... | dougmac | 5th Gen Camaro SS LS LT General Discussions | 8 | 04-20-2009 06:19 PM |
Prices have changed a little bit | ezlock83 | Camaro Price | Ordering | Tracking | Dealers Discussions | 37 | 03-05-2009 06:20 AM |