Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Header copy across workbooks
Slight variation on a common question:
Can I copy the header/footer information from a worksheet in one open workbook to a worksheet in a different open workbook? Thanks! BruceD |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Header copy across workbooks
Open up the file|page setup, show the header/footer section that you want to
copy. Copy it by selecting all of it and hitting ctrl-c. Close that dialog. Open up the other worksheet's file|page setup, show that header/footer section and paste using ctrl-v. You may end up doing it 6 times???? BruceD wrote: Slight variation on a common question: Can I copy the header/footer information from a worksheet in one open workbook to a worksheet in a different open workbook? Thanks! BruceD -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Header copy across workbooks
Thanks, Dave, that works!
But you're right - I'll have to do it 6 times. I wish there were a more streamlined way. BruceD "Dave Peterson" wrote: Open up the file|page setup, show the header/footer section that you want to copy. Copy it by selecting all of it and hitting ctrl-c. Close that dialog. Open up the other worksheet's file|page setup, show that header/footer section and paste using ctrl-v. You may end up doing it 6 times???? BruceD wrote: Slight variation on a common question: Can I copy the header/footer information from a worksheet in one open workbook to a worksheet in a different open workbook? Thanks! BruceD -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy a header and footer to multiple worksheets? | Setting up and Configuration of Excel | |||
How to Copy header/footers in Excel 2003 | Excel Discussion (Misc queries) | |||
Allow header/footer to copy to other worksheets in 1 spreadsheet. | Excel Worksheet Functions | |||
Match Header...Copy Column | Excel Discussion (Misc queries) | |||
Want to reuse a logo in a header but can't seem to copy it | Excel Discussion (Misc queries) |