Archive of Mr Excel Message Board

Back to Printing in Excel archive index
Back to archive home

Headers and footers across all worksheets

Posted by Mr R on November 08, 2001 3:25 AM

Is there any way I can quickly get a couple of rows of info to repeat across every worksheet in an Excel file. I have tried grouping the sheets and going into File, Page Setup, Sheet etc..etc.. buts with multiple sheets grouped together, the "Rows to print..." section is greyed out.

Thanks in advance,

Robin

Re: Headers and footers across all worksheets

Posted by Mark W. on November 08, 2001 6:30 AM

Group your worksheets to facilitate the
simultaneous entry of the headers and the
setting of Print Titles for all worksheets.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.