Is it possible to link the header/footer on a number of worksheets

G

Guest

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.
 
B

Bernard Liengme

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?
 
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy of Header-Footer in Excel 3
different header for different worksheets? 1
Header & Footer 5
Inserting the same header/footer on all worksheets in a workbook 7
Give multiple charts on a worksheet/workbook same header or footer 8
number worksheets in workbook 1
how to include a variable in the header and/or footer of a worksheet 2
link to a specific worksheet of a workbook with many worksheets 1

Top