MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Printing format

Posted by Bill on December 14, 1999 4:14 PM

This is really dumb but I hope someone can help.
I have a "friend" (really it's not me), that didn't plan very well, and has a sheet that extends ad infinitum to the right. Extreme left column is on "freeze panes". He wants to print his report with the left column on every page.
So, the first page of the report would be columns A-I, second page column A, then columns J-P, etc.
Thanks so much.

Posted by Bill Lean on December 14, 1999 5:08 PM

Posted by Ivan Moala on December 15, 1999 1:56 AM

clicking on File
Select Page Setup
In the page setup dialog click on the
Sheet tab
Click the Columns to repeat @ left RefEditBox
and select the column eg A1