MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Setting Prin tParameters

Posted by Lee Hitchen on October 26, 2001 11:21 AM

: I've a worksheet containing a number of separate worksheets and i wish to print them all. No problem there but some of the worksheets run to more than 1 page and I want to ensure my column 'headings' in row 1 appear on pages 2, 3 etc.

Posted by Caleb N. Diffell on October 26, 2001 11:33 AM

I could be wrong but I don't think there's any way to do that. I would suggest putting the column headings on the second and third sheets. You really should do that anyway, because to another user, the sheets may not seem logically connected and they may have trouble understanding that the column headings on sheet1 should really be for all subsequent sheets.