page break preview

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a new "sheet" in my workbook. My first sheet includes Page 1
to Page 22. I want my second sheet to start at Page 17, which I changed on
the page setup page, however, the page break preview is still showing PAGE 1.
How can I change this to show Page 17?
 
VickiJo,

If you're printing or previewing sheets separately, you'll get a starting
page number of 1. If you're printint or previewing multiple sheets, it'll
continue the page numbers from sheet to sheet. The First Page Number
(File - Page Setup - Page tab) must be set to "Auto" for that to happen. To
print-preview multiple sheets, select them, then do the print preview
command. Same for printing, or you can use "Entire workbook."
 
You must log in or register to reply here.

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

PAGE BREAK PREVIEW 1
How do I turn off page reference in page break preview 2
Page break dosen't break 4
Page break issues 1
Excel 2007 page break changes when forwarding workbooks 1
Page Break Preview 1
Printing: page count exceeds pages in tab 1
Every cell has a page break?!?! 8

Back
Top