| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print correct Page X of Y when printing single worksheet
1. Highlight all of the sheets in your print group, including those sheets you aren't printing this time. Excel will determine how many pages there are in the total print group from this. (i.e. the "Y" in "Page X of Y") 2. Select File-Print and select the individual sheet or sheets you want to print. Do a print preview and the page numbers should show the correct Page X of Y. -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=532431 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print correct Page X of Y when printing single worksheet
John,
Thank you. This worked as you said. Much appreciated. Dan "John James" wrote: 1. Highlight all of the sheets in your print group, including those sheets you aren't printing this time. Excel will determine how many pages there are in the total print group from this. (i.e. the "Y" in "Page X of Y") 2. Select File-Print and select the individual sheet or sheets you want to print. Do a print preview and the page numbers should show the correct Page X of Y. -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=532431 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print correct Page X of Y when printing single worksheet
And your appreciation is appreciated Dan. -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=532431 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print 1st Page Multiple Sheets in Same Workbook | Excel Discussion (Misc queries) | |||
| How do I print a single column of data in two columns on one page | Excel Discussion (Misc queries) | |||
| Print other worksheet by changing a Letter/# on another page. | Excel Worksheet Functions | |||
| Can I copy a worksheet with its page setup and print formats? | Excel Discussion (Misc queries) | |||
| why would page 1 of an excel worksheet print smaller of page 2 if. | Excel Discussion (Misc queries) | |||
Linear Mode
