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
zen
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
Anthony
