MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Work Book Printing & Header/Footer

Posted by Zahi on June 29, 2001 12:08 AM

How can i print whole Work Book at once.
Is there a way to use same Header/Footer for whole book.

Posted by zen on June 29, 2001 12:15 AM

highlight all of the sheet in the book and apply the header/footer


Posted by Anthony on June 29, 2001 6:23 AM

Click on the first tab of your workbook, hold down the Ctrl key, then proceed to click whichever worksheets require the same Header/Footer. Go to File > PageSetup > Header/Footer and enter the appropriate data. Upon completion, click OK and all of your worksheets will have the same Header &/or Footer.

With regard to printing the entire workbook: File > Select the print icon and under the "Print What" caption, select entire workbook.

Good Luck