MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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,


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.