printing - using common header & footer across all sheets

  • Thread starter Thread starter busyman5_au
  • Start date Start date
B

busyman5_au

(sorry if dumb question)
I have setup multiple sheets with various data and layouts and I wan
ti use the same custom header and footer on every sheet within thi
workbook... but I can't see/find where to set this.

It uses it for the workSHEET and I can't see where to set it up as th
default etc.

I am currently using Excel 2002

Thanks in anticipation
 
Hi
you have to group all sheets prior to going in the pagesetup menu. Try
the following:
- select the first worksheet
- hold down the SHIFT key and select the last worksheet
- now goto the menu 'File - Pagesetup' and define your header/footer
 
Hi busyman5

Select all the sheets, then go into Page Setup and put in the custom
header. Print Preview only works on one sheet.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 

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

transferring headers and footers 1
How do I make a single header/footer common across all worksheets? 1
Common footer but not common margins please -(Page 1 of 2) etc 9
Excel 2007 Header Doesn't Print 1
Header and Footer margins 1
Headers and Footers size 2
Entering same header & or footer into several worksheets 2
Inserting the same header/footer on all worksheets in a workbook 7

Back
Top