Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Amjad
 
Posts: n/a
Default Continuous Page No. on all worksheets

I have 10 Sheets in a workbook. I want each printing page to be numbered
automatically.

Example:
Sheet-1 has 12 pages and Sheet-2 has 20 pages. I want Sheet-2 pages number
to start 13 automatically or you can say after the last page number of the
previous sheet.
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Select the worksheet tabs you want to print (click on the first tab and
ctrl-click on subsequent).

Then file|print



Amjad wrote:

I have 10 Sheets in a workbook. I want each printing page to be numbered
automatically.

Example:
Sheet-1 has 12 pages and Sheet-2 has 20 pages. I want Sheet-2 pages number
to start 13 automatically or you can say after the last page number of the
previous sheet.


--

Dave Peterson
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
Can I uniformly scale all worksheets at once in page set-up in on. Rob W. Setting up and Configuration of Excel 2 May 3rd 23 03:41 AM
Continuous page numbers in workbook of multiple worksheets Val Excel Discussion (Misc queries) 3 June 23rd 05 07:32 PM
How can I print a specified page from several worksheets in Exce. jastmaine Excel Worksheet Functions 1 April 14th 05 09:27 PM
Auto page numbering for several worksheets Andy Excel Worksheet Functions 1 March 13th 05 04:41 AM
Print Workbook Without Page Breaks Between Worksheets annem Excel Worksheet Functions 0 December 21st 04 08:05 PM


All times are GMT +1. The time now is 05:16 PM.

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

About Us

"It's about Microsoft Excel"