You can do this from page setup e.g. In Excel 2007, the Page Setup is on the
Page Layout tab. Click the arrow in the bottom right corner of the section.
On the Sheet tab select row(s) to repeat at the top - probably $1:$1.

In page order check Over then Down. Odd pages will display the header row
from the first 'page'. Even pages will display the header row from the
second 'page'.

Excel 2003 has a similar dialog accessed from the File menu and the settings
above are available and it works in the same way.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"bmowell" wrote in message
...
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. :-)

"Doug Robbins - Word MVP" wrote:

On 31/05/2010 4:09 PM, bmowell wrote:
Hi,

I've tried to find out all day if this can be accomplished:

I am in the audio/visual industry and am trying a new script/outline
format
for video and audio production.

I'd like to carry around a letter sized binder. When I open the binder
I
will have two letter-sized pages staring back up at me, each with
bordered
tables containing columns and rows. The table on the first page (on
the
left) will have headers that designate items 1-5. The table on the
second
page (on the right) will have headers that designate items 6-10. When
I look
at the two facing pages in my binder it will be as if items 1-10 read
from
left to right across the entire two pages.

When I make revisions to a script and insert a another row, I want the
template to push the bottom row in all columns (on both pages, items
1-10)
onto two NEW pages - pages 3& 4!

Basically, it's like the two pages are really just ONE page in a
rolling
template. Is there a way to do this?

I've seriously thought about just saying to heck with it and printing
all
ten columns in landscape mode on a single 11x17 piece of paper and then
just
cutting it in half, but I'd prefer not to have to use such a large
format
printer.
It would be a lot easier to do this in Excel, with the columns sized so
that there was a page break between columns 5 and 6 and on the Sheet tab
of the Page Setup dialog, select the "Over, then down" option in the
Page order section of the dialog.

Inserting rows will then result in the output being modified in the
manner that you are after.

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