Anyone talented with Excel? - Camaro5 Chevy Camaro Forum / Camaro ZL1, SS and V6 Forums

moto-camaro · 12-02-2009, 10:20 PM

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?

*Mindz* · 12-02-2009, 10:29 PM

right click the tab, move to, check the "copy" box and it should duplicate the tab as is, formatting and all.

lawdogg149 · 12-02-2009, 10:30 PM

wife is you need me to wake her??

PQ · 12-02-2009, 10:30 PM

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.

PQ · 12-02-2009, 10:33 PM

Quote:

Originally Posted by Mindz

right click the tab, move to, check the "copy" box and it should duplicate the tab as is, formatting and all.

That's a lot quicker than mine to do the same thing. That's what I get for teaching myself. lol

*Camaro_Corvette* · 12-02-2009, 10:33 PM

moto-camaro · 12-02-2009, 10:34 PM

attempting....

PQ · 12-02-2009, 10:35 PM

Quote:

Originally Posted by moto-camaro

attempting....

Name: fingers-crossed-emoticon.gif
Views: 150
Size: 3.7 KB

moto-camaro · 12-02-2009, 10:39 PM

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

PQ · 12-02-2009, 10:42 PM

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?

Xanthos · 12-02-2009, 10:43 PM

Quote:

Originally Posted by PQ

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?

Better yet, open a new book and copy everthing into it, then undo everything back to the header.

Then never close the open book that has the copy. Instant backup.
- X

PQ · 12-02-2009, 10:48 PM

Quote:

Originally Posted by Xanthos

Better yet, open a new book and copy everthing into it, then undo everything back to the header.

Then never close the open book that has the copy. Instant backup.
- X

Well, you'd have to undo the original but it would work too.

I must not be understanding what he's doing.

Can't you just move the header?

PQ · 12-02-2009, 10:50 PM

Can you e-mail me the book? I could look at it for ya and I'd understand better?

ryftz · 12-02-2009, 10:52 PM

PROBLEM SOLVED!!! EXCEL GEEK AND BRO FTW!

12-02-2009, 10:20 PM	#1
moto-camaro CEO of the Internet Drives: the Roflcopter Join Date: Mar 2009 Location: Halifax, NS Posts: 1,282 View My Garage	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
Mindz 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. __________________ Blue Rush, 2010 SS [Car of the Week 3/22/2010] Traded in on...ZLZBUBB, 2013 ZL1

12-02-2009, 10:30 PM	#3
lawdogg149 Drives: Corvette ZO6 CSR edition #47 Join Date: Apr 2009 Location: Calhoun, GA Posts: 767 View My Garage	wife is you need me to wake her?? __________________ Nationwide Turf "artificial turf factory"

12-02-2009, 10:30 PM	#4
PQ Booooosted. Drives: 2010 Supercharged SS Join Date: Apr 2008 Location: Mobile, AL Posts: 36,716 View My Garage	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	#6
Camaro_Corvette 36.58625, -121.7568 Drives: Team 1LE Join Date: Mar 2008 Location: Earth Posts: 23,709 View My Garage	__________________ I am seriously never serious vv V vv Next order of business

12-02-2009, 10:34 PM	#7
moto-camaro CEO of the Internet Drives: the Roflcopter Join Date: Mar 2009 Location: Halifax, NS Posts: 1,282 View My Garage	attempting.... __________________

12-02-2009, 10:39 PM	#9
moto-camaro CEO of the Internet Drives: the Roflcopter Join Date: Mar 2009 Location: Halifax, NS Posts: 1,282 View My Garage	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
PQ Booooosted. Drives: 2010 Supercharged SS Join Date: Apr 2008 Location: Mobile, AL Posts: 36,716 View My Garage	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:50 PM	#13
PQ Booooosted. Drives: 2010 Supercharged SS Join Date: Apr 2008 Location: Mobile, AL Posts: 36,716 View My Garage	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
ryftz 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