| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can an Excel workbook number sheet pages sequentially?
Help please! I trying to get an Excel workbook to number it's sheets
sequentially - can this be done?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can an Excel workbook number sheet pages sequentially?
Do you mean when you print them out? You want the page numbers to be
sequential and follow on as each sheet gets printed? Pete Excel Page Numbering wrote: Help please! I trying to get an Excel workbook to number it's sheets sequentially - can this be done?? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can an Excel workbook number sheet pages sequentially?
Yes, exactly that!! Can you help? At the moment, each sheet comes out as
Page 1 ! Thanks "Pete_UK" wrote: Do you mean when you print them out? You want the page numbers to be sequential and follow on as each sheet gets printed? Pete Excel Page Numbering wrote: Help please! I trying to get an Excel workbook to number it's sheets sequentially - can this be done?? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can an Excel workbook number sheet pages sequentially?
You can group all the sheets together and then print them - this will
give you sequential numbering. To do this, select the first sheet then right-click on the sheet tab and choose Group All Sheets (the other sheet tabs will turn white, and you will see :Group in the window title bar). Then do File | Print (or you might like to do Print Preview first, just to check), and you will see the page numbers follow on from each other. You can also set the header/footer while the sheets are grouped, and this will then be applied to every sheet. Once you have finished, make sure that you un-group the sheets by right-clicking the sheet tab again. Hope this helps. Pete Excel Page Numbering wrote: Yes, exactly that!! Can you help? At the moment, each sheet comes out as Page 1 ! Thanks "Pete_UK" wrote: Do you mean when you print them out? You want the page numbers to be sequential and follow on as each sheet gets printed? Pete Excel Page Numbering wrote: Help please! I trying to get an Excel workbook to number it's sheets sequentially - can this be done?? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can an Excel workbook number sheet pages sequentially?
You are a STAR! Thanks Pete, very much appreciated
K "Pete_UK" wrote: You can group all the sheets together and then print them - this will give you sequential numbering. To do this, select the first sheet then right-click on the sheet tab and choose Group All Sheets (the other sheet tabs will turn white, and you will see :Group in the window title bar). Then do File | Print (or you might like to do Print Preview first, just to check), and you will see the page numbers follow on from each other. You can also set the header/footer while the sheets are grouped, and this will then be applied to every sheet. Once you have finished, make sure that you un-group the sheets by right-clicking the sheet tab again. Hope this helps. Pete Excel Page Numbering wrote: Yes, exactly that!! Can you help? At the moment, each sheet comes out as Page 1 ! Thanks "Pete_UK" wrote: Do you mean when you print them out? You want the page numbers to be sequential and follow on as each sheet gets printed? Pete Excel Page Numbering wrote: Help please! I trying to get an Excel workbook to number it's sheets sequentially - can this be done?? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can an Excel workbook number sheet pages sequentially?
You're welcome - thanks for the feedback.
Pete Excel Page Numbering wrote: You are a STAR! Thanks Pete, very much appreciated K "Pete_UK" wrote: You can group all the sheets together and then print them - this will give you sequential numbering. To do this, select the first sheet then right-click on the sheet tab and choose Group All Sheets (the other sheet tabs will turn white, and you will see :Group in the window title bar). Then do File | Print (or you might like to do Print Preview first, just to check), and you will see the page numbers follow on from each other. You can also set the header/footer while the sheets are grouped, and this will then be applied to every sheet. Once you have finished, make sure that you un-group the sheets by right-clicking the sheet tab again. Hope this helps. Pete Excel Page Numbering wrote: Yes, exactly that!! Can you help? At the moment, each sheet comes out as Page 1 ! Thanks "Pete_UK" wrote: Do you mean when you print them out? You want the page numbers to be sequential and follow on as each sheet gets printed? Pete Excel Page Numbering wrote: Help please! I trying to get an Excel workbook to number it's sheets sequentially - can this be done?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| macro | Excel Discussion (Misc queries) | |||
| Asked previously...can this not be done in excel | Excel Discussion (Misc queries) | |||
| Linking workbook and range protected Excel sheet to Access | Excel Discussion (Misc queries) | |||
| copy a sheet in same workbook temporary block excel | Excel Worksheet Functions | |||
Hybrid Mode
