A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Continuous page numbers in workbook of multiple worksheets



 
 
Thread Tools Display Modes
  #1  
Old June 23rd 05, 05:48 PM
Val
external usenet poster
 
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!
Ads
  #2  
Old June 23rd 05, 05:53 PM
Ron de Bruin
external usenet poster
 
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  
Old June 23rd 05, 06:31 PM
Earl Kiosterud
external usenet poster
 
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  
Old June 23rd 05, 07:32 PM
Val
external usenet poster
 
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!

>
>
>

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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 02:15 PM.


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