excel 2000 headers

  • Thread starter Thread starter David Brindle
  • Start date Start date
D

David Brindle

How do I copy headers and footers from one worksheet to
another without having to re-write them for each sheet?
Formats and Print area on each sheet within the workbook
are different

Rgds
 
David

If you are looking for a function, there isn't one to link headers and
footer. It could be written into code, or you could set up a book.xlt in
your xlStart folder, but then you would have the headers and footers for
*every* new book opened
 
Group all the sheets, then set your header / footer (Edit it slightly and reset it if already
done) and it will apply to all sheets without affecting print areas or formatting etc. Don't
forget to ungroup though when done.
 
Hi David,
Not sure exactly what you are looking for. The margins of headers
and footers is controlled by the margins of your spreadsheet so that
limits having an exact appearance from one worksheet to another.
No version of Excel provides for portrait headers and footers mixed
with a landscape oriented spreadsheet layout.

In Excel 2000 (which I also use) your normal method would be to
manually enter a decent title for the worksheet, and a subroutine
for some parts of the header and footer.

You can set up templates for book.xlt and sheet.xlt as Nick mentioned,
which can give you a consistent appearance to start with.

Until Excel 2002 came out, you could not specify the full pathname which
you would want for documentation so that you can find the workbook and
worksheet on your computer. So it was necessary to use a subroutine
or to hard code the full pathname into your footer (or header). The use
of a subroutine also allows you to make other things the same for a consistent
appearance. But with Excel 2002 you can accomplish that with a template
that includes the token for the full pathname. Subroutines provide you with
the ability to change things later, so even when I upgrade to 2002 or 2003,
I expect I will likely still be using macros for headers and/or footers.

You can run a subroutine upon command, or automatically such as when
you print. Several examples can be found in
Pathname in headings, footers, and cells
http://www.mvps.org/dmcritchie/excel/pathname.htm
 
Back
Top