[SOLVED] Print correct Page X of Y when printing single worksheet

[dbarrett44]

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?

[John James]

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.

[dbarrett44]

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
>
>

[John James]

And your appreciation is appreciated Dan.