Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can a custom header be copied to another worksheet?
I have 3 worksbooks that should have been 3 worksheets w/in a workbook. I
have no problem of copiing and pasting the data into one workbook but is there a way to copy the customer header/footer into the workbook for each sheet? |
#2
|
|||
|
|||
Roberta,
If you've copied the entire sheet (Right-click its tab - Move or Copy), instead of copy/pasting the cells within the sheet, all the Page Setup stuff, including the custom header, should come with it. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Roberta" wrote in message ... I have 3 worksbooks that should have been 3 worksheets w/in a workbook. I have no problem of copiing and pasting the data into one workbook but is there a way to copy the customer header/footer into the workbook for each sheet? |
#3
|
|||
|
|||
The header/footer were in each workbook. Instead of 3 workbooks each with 1
sheet, we decided to place them in one workbook with three sheets. So how can I get the header/footer from the other two workbooks into one? "Earl Kiosterud" wrote: Roberta, If you've copied the entire sheet (Right-click its tab - Move or Copy), instead of copy/pasting the cells within the sheet, all the Page Setup stuff, including the custom header, should come with it. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Roberta" wrote in message ... I have 3 worksbooks that should have been 3 worksheets w/in a workbook. I have no problem of copiing and pasting the data into one workbook but is there a way to copy the customer header/footer into the workbook for each sheet? |
#4
|
|||
|
|||
Roberta,
Try my earlier post. You can copy the entire sheet from one workbook to another. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Roberta" wrote in message ... The header/footer were in each workbook. Instead of 3 workbooks each with 1 sheet, we decided to place them in one workbook with three sheets. So how can I get the header/footer from the other two workbooks into one? "Earl Kiosterud" wrote: Roberta, If you've copied the entire sheet (Right-click its tab - Move or Copy), instead of copy/pasting the cells within the sheet, all the Page Setup stuff, including the custom header, should come with it. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Roberta" wrote in message ... I have 3 worksbooks that should have been 3 worksheets w/in a workbook. I have no problem of copiing and pasting the data into one workbook but is there a way to copy the customer header/footer into the workbook for each sheet? |
#5
|
|||
|
|||
Thanks for your efforts but I did a poor job of explaining my issue. I
finally realized that I cannot copy and paste a custom header from another workbook. I know that I can do it from sheet to sheet within a workbook but not from two different workbooks. "Earl Kiosterud" wrote: Roberta, Try my earlier post. You can copy the entire sheet from one workbook to another. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Roberta" wrote in message ... The header/footer were in each workbook. Instead of 3 workbooks each with 1 sheet, we decided to place them in one workbook with three sheets. So how can I get the header/footer from the other two workbooks into one? "Earl Kiosterud" wrote: Roberta, If you've copied the entire sheet (Right-click its tab - Move or Copy), instead of copy/pasting the cells within the sheet, all the Page Setup stuff, including the custom header, should come with it. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Roberta" wrote in message ... I have 3 worksbooks that should have been 3 worksheets w/in a workbook. I have no problem of copiing and pasting the data into one workbook but is there a way to copy the customer header/footer into the workbook for each sheet? |
#6
|
|||
|
|||
Roberta,
If you use the Move or Copy Sheet command I mentioned to move or copy the sheet from the individual workbooks into the consolidated workbook, the custom headers will be included. If it's too late for that (you've already started updating the sheets in the consolidated workbooks), then you can open the original workbooks, go into File - Page setup - Header - Custom header, and select and copy the header (or footer),. Then do the same in the consolidated workbook, and paste it in. It's just text, and can be copy/pasted. Do the same for the other header. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Roberta" wrote in message ... Thanks for your efforts but I did a poor job of explaining my issue. I finally realized that I cannot copy and paste a custom header from another workbook. I know that I can do it from sheet to sheet within a workbook but not from two different workbooks. "Earl Kiosterud" wrote: Roberta, Try my earlier post. You can copy the entire sheet from one workbook to another. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Roberta" wrote in message ... The header/footer were in each workbook. Instead of 3 workbooks each with 1 sheet, we decided to place them in one workbook with three sheets. So how can I get the header/footer from the other two workbooks into one? "Earl Kiosterud" wrote: Roberta, If you've copied the entire sheet (Right-click its tab - Move or Copy), instead of copy/pasting the cells within the sheet, all the Page Setup stuff, including the custom header, should come with it. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Roberta" wrote in message ... I have 3 worksbooks that should have been 3 worksheets w/in a workbook. I have no problem of copiing and pasting the data into one workbook but is there a way to copy the customer header/footer into the workbook for each sheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set a custom header as a row from the spreadsheet? | Excel Discussion (Misc queries) | |||
Custom Header and Footer | Excel Discussion (Misc queries) | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
Share Excel worksheet custom header/footer throughout workbook. | Excel Worksheet Functions | |||
Custom Header | Excel Discussion (Misc queries) |