LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
dbarrett44
 
Posts: n/a
Default Print correct Page X of Y when printing single worksheet

I have a workbook with multiple worksheets tabs. I use the Page X of Y on
each page footer. When I print a single worksheet from the group, the footer
prints "Page 1 of 1", even if it is really sheet 5 of the group. How can I
print single pages with the correct page numbers?
 
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 1st Page Multiple Sheets in Same Workbook Ben Dummar Excel Discussion (Misc queries) 8 May 22nd 07 09:18 PM
How do I print a single column of data in two columns on one page Neal Excel Discussion (Misc queries) 1 January 8th 06 11:31 PM
Print other worksheet by changing a Letter/# on another page. Rob Excel Worksheet Functions 1 October 1st 05 06:16 PM
Can I copy a worksheet with its page setup and print formats? MSSAC_QA Excel Discussion (Misc queries) 2 July 14th 05 02:24 PM
why would page 1 of an excel worksheet print smaller of page 2 if. hisdrama pest Excel Discussion (Misc queries) 1 January 10th 05 07:14 PM


All times are GMT +1. The time now is 08:02 PM.

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

About Us

"It's about Microsoft Excel"