Printing: page count exceeds pages in tab

D

Dave O

Troubleshooting a colleague's file: he wants to show "Page X of Y" in
the footer of a 5 page tab. Print preview shows "Page 7 of 5" and it
appears that way on paper as well. There are no hidden rows or
columns; no conflicting PrintArea named ranges; the expected number of
page breaks. What would cause this / what's the fix?

Thanks
Dave O
 
G

Gord Dibben

You don't state which version of Excel but in Page Setup>Page you can
have a look at the "First Page Number"

Usually set to "Auto" but someone may have changed it to 3


Gord
 

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

Similar Threads

Print Preview and hard copy cut off in mid page 0
Duplicate entry in TOC 0
Display page number in footer based upon pages in the current tab 1
Page X of Y printing incorrect numbers 1
Mysterious "Arc" appearing at the bottom of the page 6
Page Breaks - Can they be ignored? 2
"page of pages" for report groups 4
Page of Pages printing error on Word 2000 2

Top