Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / October 2006

Tip: Looking for answers? Try searching our database.

Can an Excel workbook number sheet pages sequentially?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Excel Page Numbering - 18 Oct 2006 13:54 GMT
Help please! I trying to get an Excel workbook to number it's sheets
sequentially - can this be done??
Pete_UK - 18 Oct 2006 14:22 GMT
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

> Help please! I trying to get an Excel workbook to number it's sheets
> sequentially - can this be done??
Excel Page Numbering - 18 Oct 2006 15:24 GMT
Yes, exactly that!!  Can you help? At the moment, each sheet comes out as
Page 1 !
Thanks

> Do you mean when you print them out? You want the page numbers to be
> sequential and follow on as each sheet gets printed?
[quoted text clipped - 3 lines]
> > Help please! I trying to get an Excel workbook to number it's sheets
> > sequentially - can this be done??
Pete_UK - 18 Oct 2006 16:08 GMT
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

> Yes, exactly that!!  Can you help? At the moment, each sheet comes out as
> Page 1 !
[quoted text clipped - 7 lines]
> > > Help please! I trying to get an Excel workbook to number it's sheets
> > > sequentially - can this be done??
Excel Page Numbering - 18 Oct 2006 16:19 GMT
You are a STAR! Thanks Pete, very much appreciated
K

> 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
[quoted text clipped - 23 lines]
> > > > Help please! I trying to get an Excel workbook to number it's sheets
> > > > sequentially - can this be done??
Pete_UK - 18 Oct 2006 16:47 GMT
You're welcome - thanks for the feedback.

Pete

> You are a STAR! Thanks Pete, very much appreciated
> K
[quoted text clipped - 26 lines]
> > > > > Help please! I trying to get an Excel workbook to number it's sheets
> > > > > sequentially - can this be done??
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.