Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 23rd 05, 05:48 PM
Val
 
Posts: n/a
Default Continuous page numbers in workbook of multiple worksheets

I would like the page numbers to start with 1 on the first worksheet in a
workbook and then have the next worksheet pick up with where the first
worksheet left off. For example, if the first worksheet has 2 pages and the
second worksheet in the workbook had 3 pages, then the first worksheet would
contain pages 1 and 2 while the 2nd worksheet would contain pages 3, 4, and
5. Is there a way to have Excel figure out what the first page number should
be in the 2nd worksheet or do I always have to manually update it in Page
setup.

THANKS!

  #2   Report Post  
Old June 23rd 05, 05:53 PM
Ron de Bruin
 
Posts: n/a
Default

Hi Val

Select all sheets first (right click on a sheet tab)
Print
Ungroup the sheets


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Val" wrote in message ...
I would like the page numbers to start with 1 on the first worksheet in a
workbook and then have the next worksheet pick up with where the first
worksheet left off. For example, if the first worksheet has 2 pages and the
second worksheet in the workbook had 3 pages, then the first worksheet would
contain pages 1 and 2 while the 2nd worksheet would contain pages 3, 4, and
5. Is there a way to have Excel figure out what the first page number should
be in the 2nd worksheet or do I always have to manually update it in Page
setup.

THANKS!



  #3   Report Post  
Old June 23rd 05, 06:31 PM
Earl Kiosterud
 
Posts: n/a
Default

Val,

In File - Page setup - Page tab, the "First page number" box must be set to
"Auto." And you have to have put page number codes in your header, which I
think you've already done. If not, it's File - Page Setup - Header/Footer -
Header (or Footer). It's the &[Page] code you need. Now you have to print
it as one print job, either by selecting the sheets, then doing one print,
or using the entire workbook option in File - Print.

--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------

"Ron de Bruin" wrote in message
...
Hi Val

Select all sheets first (right click on a sheet tab)
Print
Ungroup the sheets


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Val" wrote in message
...
I would like the page numbers to start with 1 on the first worksheet in a
workbook and then have the next worksheet pick up with where the first
worksheet left off. For example, if the first worksheet has 2 pages and
the
second worksheet in the workbook had 3 pages, then the first worksheet
would
contain pages 1 and 2 while the 2nd worksheet would contain pages 3, 4,
and
5. Is there a way to have Excel figure out what the first page number
should
be in the 2nd worksheet or do I always have to manually update it in Page
setup.

THANKS!





  #4   Report Post  
Old June 23rd 05, 07:32 PM
Val
 
Posts: n/a
Default

Thanks.


"Ron de Bruin" wrote:

Hi Val

Select all sheets first (right click on a sheet tab)
Print
Ungroup the sheets


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Val" wrote in message ...
I would like the page numbers to start with 1 on the first worksheet in a
workbook and then have the next worksheet pick up with where the first
worksheet left off. For example, if the first worksheet has 2 pages and the
second worksheet in the workbook had 3 pages, then the first worksheet would
contain pages 1 and 2 while the 2nd worksheet would contain pages 3, 4, and
5. Is there a way to have Excel figure out what the first page number should
be in the 2nd worksheet or do I always have to manually update it in Page
setup.

THANKS!






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
print multiple copies of the same page with sequential numbers labrat Excel Discussion (Misc queries) 1 June 14th 05 05:32 PM
Saving as web page for workbook with frozen panes tawne Excel Discussion (Misc queries) 0 January 19th 05 08:47 PM
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 3 December 31st 04 11:31 AM
"countif" from multiple worksheets within workbook Excel Discussion (Misc queries) 2 December 10th 04 07:59 PM
insert multiple page Word document into Excel S.W. Excel Discussion (Misc queries) 2 December 8th 04 12:29 AM


All times are GMT +1. The time now is 06:39 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017