By carefully adjusting the column widths, I have set the 1st page to include columns A to Z and rows 1 to 67. So, in the 'Over then down' page setup, the 2nd page is from AA1-AZ67.

That's good but my current excel window is displaying too many 'pages' across the work sheet. It just looks like that the worksheet now has an infinite number of columns.

How do I select the worksheet to include and display only columns A to AZ so that the printing goes over two pages and then down?

And, how do I choose to highlight the lines delineating the pages on the worksheet, preferably with watermarks showing the page number on each page?

Attached Files

New.xls (14.5 KB, 9 views)