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?



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.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question