|
Page numbers 1 of 14 not 1 of 1
Hi All,
I've add the page footer pages # of # however on each page its coming up with 1 of 1. There are about 14 worksheets in the workbook so why isn't it showing 1 of 14 on the last sheet? -- Adam ----------- Windows 98 + Office Pro 97 |
Group your Worksheets before printing.
-- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Adam" wrote in message ... Hi All, I've add the page footer pages # of # however on each page its coming up with 1 of 1. There are about 14 worksheets in the workbook so why isn't it showing 1 of 14 on the last sheet? -- Adam ----------- Windows 98 + Office Pro 97 |
Some of the worksheets print over 3 pages, so grouping and then adding the
the footer removes the page breaks on those pages. "RagDyeR" wrote: Group your Worksheets before printing. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Adam" wrote in message ... Hi All, I've add the page footer pages # of # however on each page its coming up with 1 of 1. There are about 14 worksheets in the workbook so why isn't it showing 1 of 14 on the last sheet? -- Adam ----------- Windows 98 + Office Pro 97 |
Are you saying that you want the 3 *Print Pages* of Sheet 1 to display,
"Page 1 of 14"? AND ... have Sheet 2 display "Page 2 of 14"? If you manually set the page breaks, and then Group and print the WB, the page breaks remain in force, and pick up their own page number. So, if Sheet 1 had 3 *print pages*, and all the other 13 sheets had 1 each, you'd end up with 16 page numbers. What *exactly* are you looking to accomplish? -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "Adam" wrote in message ... Some of the worksheets print over 3 pages, so grouping and then adding the the footer removes the page breaks on those pages. "RagDyeR" wrote: Group your Worksheets before printing. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Adam" wrote in message ... Hi All, I've add the page footer pages # of # however on each page its coming up with 1 of 1. There are about 14 worksheets in the workbook so why isn't it showing 1 of 14 on the last sheet? -- Adam ----------- Windows 98 + Office Pro 97 |
I'm trying to achieve your first point here. However when I group and apply
the footer "Pages 1 of ?" it removes my page breaks on the sheet which 3 pages. "RagDyeR" wrote: Are you saying that you want the 3 *Print Pages* of Sheet 1 to display, "Page 1 of 14"? AND ... have Sheet 2 display "Page 2 of 14"? If you manually set the page breaks, and then Group and print the WB, the page breaks remain in force, and pick up their own page number. So, if Sheet 1 had 3 *print pages*, and all the other 13 sheets had 1 each, you'd end up with 16 page numbers. What *exactly* are you looking to accomplish? -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "Adam" wrote in message ... Some of the worksheets print over 3 pages, so grouping and then adding the the footer removes the page breaks on those pages. "RagDyeR" wrote: Group your Worksheets before printing. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Adam" wrote in message ... Hi All, I've add the page footer pages # of # however on each page its coming up with 1 of 1. There are about 14 worksheets in the workbook so why isn't it showing 1 of 14 on the last sheet? -- Adam ----------- Windows 98 + Office Pro 97 |
I'm wondering if the OPs format in the footer is correct. It should display
in the Custom Footer setup window as "&[Page] of &[Pages]". It looks like it may be # of # which, for page 1 would show 1 of 1 (page 2 would show 2 of 2, etc.). Worth a look see, anyway. Bruce "Adam" wrote: I'm trying to achieve your first point here. However when I group and apply the footer "Pages 1 of ?" it removes my page breaks on the sheet which 3 pages. "RagDyeR" wrote: Are you saying that you want the 3 *Print Pages* of Sheet 1 to display, "Page 1 of 14"? AND ... have Sheet 2 display "Page 2 of 14"? If you manually set the page breaks, and then Group and print the WB, the page breaks remain in force, and pick up their own page number. So, if Sheet 1 had 3 *print pages*, and all the other 13 sheets had 1 each, you'd end up with 16 page numbers. What *exactly* are you looking to accomplish? -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "Adam" wrote in message ... Some of the worksheets print over 3 pages, so grouping and then adding the the footer removes the page breaks on those pages. "RagDyeR" wrote: Group your Worksheets before printing. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Adam" wrote in message ... Hi All, I've add the page footer pages # of # however on each page its coming up with 1 of 1. There are about 14 worksheets in the workbook so why isn't it showing 1 of 14 on the last sheet? -- Adam ----------- Windows 98 + Office Pro 97 |
I am now at an XL97 machine, and I have no problem with creating and
*maintaining* page breaks on Sheet 1, while grouping and setting up page numbering footers for *all* the rest of the sheets. I don't understand what you are doing that "loses" your page breaks. However, all printed pages will be numbered *sequentially* if printing is initiated while the sheets are grouped. You can experiment with printing the sheets individually, where you control the numbering of the first page for each sheet in: <File <PageSetup <Page tab, And change the default "Automatic" setting, in the "FirstPageNumbering" box to different numbers. HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Adam" wrote in message ... I'm trying to achieve your first point here. However when I group and apply the footer "Pages 1 of ?" it removes my page breaks on the sheet which 3 pages. "RagDyeR" wrote: Are you saying that you want the 3 *Print Pages* of Sheet 1 to display, "Page 1 of 14"? AND ... have Sheet 2 display "Page 2 of 14"? If you manually set the page breaks, and then Group and print the WB, the page breaks remain in force, and pick up their own page number. So, if Sheet 1 had 3 *print pages*, and all the other 13 sheets had 1 each, you'd end up with 16 page numbers. What *exactly* are you looking to accomplish? -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "Adam" wrote in message ... Some of the worksheets print over 3 pages, so grouping and then adding the the footer removes the page breaks on those pages. "RagDyeR" wrote: Group your Worksheets before printing. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Adam" wrote in message ... Hi All, I've add the page footer pages # of # however on each page its coming up with 1 of 1. There are about 14 worksheets in the workbook so why isn't it showing 1 of 14 on the last sheet? -- Adam ----------- Windows 98 + Office Pro 97 |
| All times are GMT +1. The time now is 09:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com