A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Page Layout
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old May 31st, 2010, 07:09 AM posted to microsoft.public.word.pagelayout
bmowell
external usenet poster
 
Posts: 10
Default A tough one? Two page template with separate headers and rolling.

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.
  #2  
Old May 31st, 2010, 08:19 AM posted to microsoft.public.word.pagelayout
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default A tough one? Two page template with separate headers and rolling.

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.
  #3  
Old May 31st, 2010, 10:08 AM posted to microsoft.public.word.pagelayout
bmowell
external usenet poster
 
Posts: 10
Default A tough one? Two page template with separate headers and roll

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

  #4  
Old May 31st, 2010, 10:33 AM posted to microsoft.public.word.pagelayout
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default A tough one? Two page template with separate headers and roll

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.
  #5  
Old May 31st, 2010, 10:42 AM posted to microsoft.public.word.pagelayout
Graham Mayor
external usenet poster
 
Posts: 18,297
Default A tough one? Two page template with separate headers and roll

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



  #6  
Old May 31st, 2010, 07:19 PM posted to microsoft.public.word.pagelayout
bmowell
external usenet poster
 
Posts: 10
Default A tough one? Two page template with separate headers and roll

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

"Graham Mayor" wrote:

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



.

  #7  
Old May 31st, 2010, 07:19 PM posted to microsoft.public.word.pagelayout
bmowell
external usenet poster
 
Posts: 10
Default A tough one? Two page template with separate headers and roll

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

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:33 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.