Page Breaks

[Keith]

How do I get A1:G25 to print as page one and A30:G55 to print as page two
respectively?

I've tried inserting page breaks and moving the "blue lines" in page break
preview to no avail. F1 has not been very helpful.

Thanks,

Keith

[Myrna Larson]

Have you tried setting a page break after row 29?

On Sun, 6 Mar 2005 19:24:05 -0700, "Keith" <[email protected]> wrote:

>How do I get A1:G25 to print as page one and A30:G55 to print as page two
>respectively?
>
>I've tried inserting page breaks and moving the "blue lines" in page break
>preview to no avail. F1 has not been very helpful.
>
>Thanks,
>
>Keith
>

[Keith]

Yes, I've tried that. Inserting page breaks to have no effect at all.
Thanks,
Keith


"Myrna Larson" <[email protected]> wrote in message
news:[email protected]...
> Have you tried setting a page break after row 29?
>
> On Sun, 6 Mar 2005 19:24:05 -0700, "Keith" <[email protected]> wrote:
>
> >How do I get A1:G25 to print as page one and A30:G55 to print as page two
> >respectively?
> >
> >I've tried inserting page breaks and moving the "blue lines" in page
break
> >preview to no avail. F1 has not been very helpful.
> >
> >Thanks,
> >
> >Keith
> >
>

[Ragdyer]

Exactly what problem are you having?

Printing wrong pages, no pages ???

After dragging the page break lines, I had no trouble printing the ranges
you mentioned.

I did however *HIDE* rows 26 to 29 first!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Keith" <[email protected]> wrote in message
news:[email protected]...
> Yes, I've tried that. Inserting page breaks to have no effect at all.
> Thanks,
> Keith
>
>
> "Myrna Larson" <[email protected]> wrote in message
> news:[email protected]...
> > Have you tried setting a page break after row 29?
> >
> > On Sun, 6 Mar 2005 19:24:05 -0700, "Keith" <[email protected]> wrote:
> >
> > >How do I get A1:G25 to print as page one and A30:G55 to print as page
two
> > >respectively?
> > >
> > >I've tried inserting page breaks and moving the "blue lines" in page
> break
> > >preview to no avail. F1 has not been very helpful.
> > >
> > >Thanks,
> > >
> > >Keith
> > >
> >
>
>

[David McRitchie]

Possibly you used
File, Page Setup, Page (Tab), Fit to 1 pages tall by 1 pages wide
put the tick on the other choice.

By the way pages tall and pages wide are two independent settings,
you can use either or both. In your case you don't want them.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Keith" <[email protected]> wrote in message news:[email protected]...
> Yes, I've tried that. Inserting page breaks to have no effect at all.
> Thanks,
> Keith
>
>
> "Myrna Larson" <[email protected]> wrote in message
> news:[email protected]...
> > Have you tried setting a page break after row 29?
> >
> > On Sun, 6 Mar 2005 19:24:05 -0700, "Keith" <[email protected]> wrote:
> >
> > >How do I get A1:G25 to print as page one and A30:G55 to print as page two
> > >respectively?
> > >
> > >I've tried inserting page breaks and moving the "blue lines" in page
> break
> > >preview to no avail. F1 has not been very helpful.
> > >
> > >Thanks,
> > >
> > >Keith
> > >
> >
>
>

[Keith]

YES, that was it....I changed the selection to "adjust to" in page setup and
the page breaks went right to where I had set them.... many thanks,
Keith

"David McRitchie" <[email protected]> wrote in message
news:[email protected]...
> Possibly you used
> File, Page Setup, Page (Tab), Fit to 1 pages tall by 1 pages wide
> put the tick on the other choice.
>
> By the way pages tall and pages wide are two independent settings,
> you can use either or both. In your case you don't want them.
>
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Keith" <[email protected]> wrote in message
news:[email protected]...
> > Yes, I've tried that. Inserting page breaks to have no effect at all.
> > Thanks,
> > Keith
> >
> >
> > "Myrna Larson" <[email protected]> wrote in message
> > news:[email protected]...
> > > Have you tried setting a page break after row 29?
> > >
> > > On Sun, 6 Mar 2005 19:24:05 -0700, "Keith" <[email protected]> wrote:
> > >
> > > >How do I get A1:G25 to print as page one and A30:G55 to print as page
two
> > > >respectively?
> > > >
> > > >I've tried inserting page breaks and moving the "blue lines" in page
> > break
> > > >preview to no avail. F1 has not been very helpful.
> > > >
> > > >Thanks,
> > > >
> > > >Keith
> > > >
> > >
> >
> >
>
>