A tough one? Two page template with separate headers and roll
in [Page Layout]
|
Prev: A tough one? Two page template with separate headers and rolling.
Next: Centre align if less than one line of text
From: bmowell on 31 May 2010 05:08 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. > . >
From: Doug Robbins - Word MVP on 31 May 2010 05:33 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.
From: Graham Mayor on 31 May 2010 05:42 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" <bmowell(a)discussions.microsoft.com> wrote in message news:70DE2900-8894-4949-B174-3957710F611F(a)microsoft.com... > 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. >> . >>
From: bmowell on 31 May 2010 14:19
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" <bmowell(a)discussions.microsoft.com> wrote in message > news:70DE2900-8894-4949-B174-3957710F611F(a)microsoft.com... > > 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. > >> . > >> > > > . > |