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?