If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Applying a Header to Workbook
How do I apply a header to an entire workbook? What I
really want is for the header to print on every page. I would also like the page numbers to appear as the footer. Thanks for your help, Kerri |
#2
|
|||
|
|||
Applying a Header to Workbook
You need to right click over any Sheet tab and choose
Select all sheets. The tabs will all appear white. This means that they are linked and whatever you do to one sheet will be done to them all. Go ahead and insert the Header and Footer as normal. Hope this helps Judith -----Original Message----- How do I apply a header to an entire workbook? What I really want is for the header to print on every page. I would also like the page numbers to appear as the footer. Thanks for your help, Kerri . |
#3
|
|||
|
|||
Applying a Header to Workbook
Hi Kerri,
You would need to use a workbook event macro in ThisWorkBook. Using Workbook_BeforePrint to automate printing of heading/footing (#beforeprint) http://www.mvps.org/dmcritchie/excel...tm#beforeprint --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Kerri" wrote in message ... How do I apply a header to an entire workbook? What I really want is for the header to print on every page. I would also like the page numbers to appear as the footer. Thanks for your help, Kerri |
#4
|
|||
|
|||
Applying a Header to Workbook
From the file menu select Page Setup
Choose the Header Footer Tab and then select Custom Header for your title, you can play around with fonts and sizes. For page numbering choose Custom Footer and select the icon with +'s on it, or alternatively type in &[Pages] TGHCOGO --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Header formatting in LINKed docs not working | Dennis | Page Layout | 4 | July 5th, 2004 10:04 AM |
Saved Workbook and the Whole workbook is now Protected | Beth | New Users | 1 | June 16th, 2004 03:27 PM |
Can you make a workbook run like a program? | Kurt | Worksheet Functions | 5 | February 13th, 2004 02:19 PM |
Excel Gurus = want a macro in 1 workbook to get info from another workbook = Read please | harry | Worksheet Functions | 1 | December 20th, 2003 01:32 AM |
Copying a sheet from one workbook to another creates a link | Centurion | Worksheet Functions | 1 | December 5th, 2003 01:33 AM |