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.