Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Page Numbers on Worksheet in Excel 2007
In Excel 2003, if you wanted to put page numbers on multiple worksheets in a
workbook, you grouped the worksheets and then added a header or footer, using the page number function. All of your grouped worksheets would shows its own page number. But in Excel 2007, only my first worksheet is numbered when I do this (as Page 1). What's the problem? Do I actually have to put a page number, one by one, on each worksheet? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Page Numbers on Worksheet in Excel 2007
I cannot replicate your problem with 2007.
Grouped sheets behave exactly as 2003 did. After grouping and adding a header of Page 1 did you do a print preview with the grouped sheets? Only Page 1 was showing? None of the other pages had a header? Gord Dibben MS Excel MVP On Wed, 27 Jan 2010 14:50:02 -0800, Stratuser wrote: In Excel 2003, if you wanted to put page numbers on multiple worksheets in a workbook, you grouped the worksheets and then added a header or footer, using the page number function. All of your grouped worksheets would shows its own page number. But in Excel 2007, only my first worksheet is numbered when I do this (as Page 1). What's the problem? Do I actually have to put a page number, one by one, on each worksheet? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Page Numbers on Worksheet in Excel 2007
Yes, I did a print preview with the grouped sheets, and no page except the
first page had a header. So that put me in the position of having to do an individual header for each of 15 worksheets (Page 1, Page 2, ...Page 15), which I don't want to do. "Gord Dibben" wrote: I cannot replicate your problem with 2007. Grouped sheets behave exactly as 2003 did. After grouping and adding a header of Page 1 did you do a print preview with the grouped sheets? Only Page 1 was showing? None of the other pages had a header? Gord Dibben MS Excel MVP On Wed, 27 Jan 2010 14:50:02 -0800, Stratuser wrote: In Excel 2003, if you wanted to put page numbers on multiple worksheets in a workbook, you grouped the worksheets and then added a header or footer, using the page number function. All of your grouped worksheets would shows its own page number. But in Excel 2007, only my first worksheet is numbered when I do this (as Page 1). What's the problem? Do I actually have to put a page number, one by one, on each worksheet? . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Page Numbers on Worksheet in Excel 2007
I found a way of getting around the problem. I went to Page Layout, and then
to Print Titles, and there I put in the header. For some reason, it worked, although it hadn't worked when I tried going into Print Preview and putting in the header from there. "Stratuser" wrote: Yes, I did a print preview with the grouped sheets, and no page except the first page had a header. So that put me in the position of having to do an individual header for each of 15 worksheets (Page 1, Page 2, ...Page 15), which I don't want to do. "Gord Dibben" wrote: I cannot replicate your problem with 2007. Grouped sheets behave exactly as 2003 did. After grouping and adding a header of Page 1 did you do a print preview with the grouped sheets? Only Page 1 was showing? None of the other pages had a header? Gord Dibben MS Excel MVP On Wed, 27 Jan 2010 14:50:02 -0800, Stratuser wrote: In Excel 2003, if you wanted to put page numbers on multiple worksheets in a workbook, you grouped the worksheets and then added a header or footer, using the page number function. All of your grouped worksheets would shows its own page number. But in Excel 2007, only my first worksheet is numbered when I do this (as Page 1). What's the problem? Do I actually have to put a page number, one by one, on each worksheet? . |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Page Numbers on Worksheet in Excel 2007
Have you tried the same operation on a new workbook?
Open a new book and group the sheets. Enter something in A1 and copy down to A100. Setup the header and preview. Same thing? As I stated in first reply............I cannot replicate your problem in 2007 so not much help. Gord On Thu, 28 Jan 2010 06:36:02 -0800, Stratuser wrote: Yes, I did a print preview with the grouped sheets, and no page except the first page had a header. So that put me in the position of having to do an individual header for each of 15 worksheets (Page 1, Page 2, ...Page 15), which I don't want to do. "Gord Dibben" wrote: I cannot replicate your problem with 2007. Grouped sheets behave exactly as 2003 did. After grouping and adding a header of Page 1 did you do a print preview with the grouped sheets? Only Page 1 was showing? None of the other pages had a header? Gord Dibben MS Excel MVP On Wed, 27 Jan 2010 14:50:02 -0800, Stratuser wrote: In Excel 2003, if you wanted to put page numbers on multiple worksheets in a workbook, you grouped the worksheets and then added a header or footer, using the page number function. All of your grouped worksheets would shows its own page number. But in Excel 2007, only my first worksheet is numbered when I do this (as Page 1). What's the problem? Do I actually have to put a page number, one by one, on each worksheet? . |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Page Numbers on Worksheet in Excel 2007
I see.
I always go through Print Titles or FilePage Setup............never tried through Print Preview. Same behaviour in Excel 2003. Only adds Page number(s) to first worksheet when seet up from Print Preview. Just never noticed. Thanks for posting back with resolution. Gord On Thu, 28 Jan 2010 09:27:01 -0800, Stratuser wrote: I found a way of getting around the problem. I went to Page Layout, and then to Print Titles, and there I put in the header. For some reason, it worked, although it hadn't worked when I tried going into Print Preview and putting in the header from there. "Stratuser" wrote: Yes, I did a print preview with the grouped sheets, and no page except the first page had a header. So that put me in the position of having to do an individual header for each of 15 worksheets (Page 1, Page 2, ...Page 15), which I don't want to do. "Gord Dibben" wrote: I cannot replicate your problem with 2007. Grouped sheets behave exactly as 2003 did. After grouping and adding a header of Page 1 did you do a print preview with the grouped sheets? Only Page 1 was showing? None of the other pages had a header? Gord Dibben MS Excel MVP On Wed, 27 Jan 2010 14:50:02 -0800, Stratuser wrote: In Excel 2003, if you wanted to put page numbers on multiple worksheets in a workbook, you grouped the worksheets and then added a header or footer, using the page number function. All of your grouped worksheets would shows its own page number. But in Excel 2007, only my first worksheet is numbered when I do this (as Page 1). What's the problem? Do I actually have to put a page number, one by one, on each worksheet? . |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Page Numbers on Worksheet in Excel 2007
The same thing happened with a new workbook. If I insert a page header in
Print Preview, it shows up only on the first grouped worksheet (although in this case the worksheet spills over onto two pages and I get a "Page 2"). But if I insert the page header in Print Titles, the page numbers show up on every grouped worksheet. Well, it's a bug, but at least I know a workaround now. "Gord Dibben" wrote: Have you tried the same operation on a new workbook? Open a new book and group the sheets. Enter something in A1 and copy down to A100. Setup the header and preview. Same thing? As I stated in first reply............I cannot replicate your problem in 2007 so not much help. Gord On Thu, 28 Jan 2010 06:36:02 -0800, Stratuser wrote: Yes, I did a print preview with the grouped sheets, and no page except the first page had a header. So that put me in the position of having to do an individual header for each of 15 worksheets (Page 1, Page 2, ...Page 15), which I don't want to do. "Gord Dibben" wrote: I cannot replicate your problem with 2007. Grouped sheets behave exactly as 2003 did. After grouping and adding a header of Page 1 did you do a print preview with the grouped sheets? Only Page 1 was showing? None of the other pages had a header? Gord Dibben MS Excel MVP On Wed, 27 Jan 2010 14:50:02 -0800, Stratuser wrote: In Excel 2003, if you wanted to put page numbers on multiple worksheets in a workbook, you grouped the worksheets and then added a header or footer, using the page number function. All of your grouped worksheets would shows its own page number. But in Excel 2007, only my first worksheet is numbered when I do this (as Page 1). What's the problem? Do I actually have to put a page number, one by one, on each worksheet? . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to insert web page content into excel worksheet? | Excel Discussion (Misc queries) | |||
Need to Insert Page Number Watermark in Excel 2007 | Excel Discussion (Misc queries) | |||
How do I insert page numbers on an Excel report. | Excel Discussion (Misc queries) | |||
How do I insert page numbers in many work sheets in excel? | Excel Worksheet Functions | |||
How do insert page numbers in excel | Excel Discussion (Misc queries) |