MrExcel.com - Your One Stop for Excel Tips & Solutions

Formatting pages for print.

Posted by Lee Hitchen on October 26, 2001 1:45 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.

If I select all sheets and go to Page Setup, Sheet, Rows to repeat at top I can't enter anything as it is 'greyed' out. I think this option only works if you are working with a single sheet.

Anybody got a solution?

Regards

Lee

Posted by Lee Hitchen on October 26, 2001 2:09 AM

Posted by Carol on October 26, 2001 4:29 AM

I believe you have to go to each worksheet individually and select Page Setup, Sheet, Rows to repeat at top. After you've done it for each worksheet, you can select & print all worksheets at once.