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?

 

[Keith]

Yes, I've tried that. Inserting page breaks to have no effect at all.
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!

 

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

 

[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

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

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