On 31/05/2010 7:08 PM, bmowell wrote:
Doug,

Thanks! That works great for pushing the bottom row and columns onto the
next two pages, however I still don't see a way to be able to carry the cells
that contain my column names onto the two new pages without doing it
manually. I have not been using headers because I couldn't figure out how to
have different headers (1-10) across the original two pages - it would only
let me have duplicate headers from page one to page two.

Any ideas? lol. :-)


Put the column headings as the first row(s) of the sheet and set those
rows as the "Rows to repeat at top" in the Print titles section on the
Sheet tab of the Page Setup dialog. (Those rows should then be excluded
from the "Print area" that you can set via that same dialog so that they
are not duplicated on the first printed pages.)

--
Hope this helps,
Doug Robbins - Word MVP
Please reply to the newsgroup unless you want to obtain my services on a
professional basis.