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?

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

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

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