Printing with Frozen Panes

[jared.tesche]

I have a worksheet that has become quite wide, and would like to print the sheet so it spans about 30". I am trying to set it up so that I can print 2 or possibly 3 pages with the panes that I have frozen on each page.

ex. Page 1 - A,B,C,D......Z ; Page 2 - A,B,C,AA,AB.....AZ etc.

I have the columns left of D frozen, and the rows above 8 frozen and would like to be able to see the headings in those frozen panes on each page.

Thank you for the help!

Jared

[6StringJazzer]

You have to set this up separately from Freeze Panes, but it's easy.

In the Ribbon, Page Layout panel, click the little arrow in the lower right corner to open a dialog box, and select the Sheet tab. Set up "Rows to repeat at top" and "columns to repeat on left".

I use 2007 but I believe the interface should be the same as 2010.