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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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?
 
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
Change Header & Footer Info w/ Worksheet Option Buttons 1
Headers & footers 3
Linking cells to Headers and Footers 4
Give multiple charts on a worksheet/workbook same header or footer 8
Setting up Default Headers/Footers in Excel 3
Headers & Footers _auto update info from a cell in the worksheet 4
Different headers, same footers on multiple worksheets 2

Back
Top