Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page Breaks | Excel Worksheet Functions | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
excel page breaks - urgent help required | Excel Worksheet Functions | |||
How do I keep page breaks for each page in a sheet without the co. | Excel Discussion (Misc queries) | |||
Page breaks don't show on screen and don't print separately. It i. | Excel Discussion (Misc queries) |