Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to link the header/footer on a number of worksheets
I am using an excel workbook to record details of building surveys at a large
site. The site contains many buildings and I am using a worksheet for each structure. Is it possible to link headers from eachworksheet to the others so that you can print out a sequentially paginated hard copy report. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to link the header/footer on a number of worksheets
Not too clear what you need.
You can have, for example, a master sheet with formulas such as =Sheet1!A1 to bock up data from other sheets. Any help? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Grahame19" wrote in message ... I am using an excel workbook to record details of building surveys at a large site. The site contains many buildings and I am using a worksheet for each structure. Is it possible to link headers from eachworksheet to the others so that you can print out a sequentially paginated hard copy report. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to link the header/footer on a number of worksheets
Grahame,
You should be able to select the "Entire Workbook" option under "Print What" in the File:Print dialog box. If you have page headers/footers set up on each worksheet, then Excel will automatically paginate them across all worksheets. Does that help? "Grahame19" wrote: I am using an excel workbook to record details of building surveys at a large site. The site contains many buildings and I am using a worksheet for each structure. Is it possible to link headers from eachworksheet to the others so that you can print out a sequentially paginated hard copy report. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link lots of data in multiple worksheets | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
How to link worksheets so editing one will edit others automatica | Excel Worksheet Functions | |||
how do i link a list of items in a workbook to worksheets in the . | Excel Discussion (Misc queries) |