Page Breaks
 

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

Have you tried setting a page break after row 29?

On Sun, 6 Mar 2005 19:24:05 -0700, "Keith" 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

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


"Myrna Larson" wrote in message
...
Have you tried setting a page break after row 29?

On Sun, 6 Mar 2005 19:24:05 -0700, "Keith" 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

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" wrote in message
...
Yes, I've tried that. Inserting page breaks to have no effect at all.
Thanks,
Keith


"Myrna Larson" wrote in message
...
Have you tried setting a page break after row 29?

On Sun, 6 Mar 2005 19:24:05 -0700, "Keith" 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

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" wrote in message ...
Yes, I've tried that. Inserting page breaks to have no effect at all.
Thanks,
Keith


"Myrna Larson" wrote in message
...
Have you tried setting a page break after row 29?

On Sun, 6 Mar 2005 19:24:05 -0700, "Keith" 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

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" wrote in message
...
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" wrote in message
...
Yes, I've tried that. Inserting page breaks to have no effect at all.
Thanks,
Keith


"Myrna Larson" wrote in message
...
Have you tried setting a page break after row 29?

On Sun, 6 Mar 2005 19:24:05 -0700, "Keith" 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