A tough one? Two page template with separate headers and rolling.

[bmowell]

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.

 

[Doug Robbins - Word MVP]

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.

 

[bmowell]

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]

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.)

 

[Graham Mayor]

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[bmowell]

Wow! You guys are great! Thank you so much!

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.
.

 

[bmowell]

Wow! You guys are great! Thank you so much!

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>





.