Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
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." -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "VickiJo" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Page scaling & Page break preview prob | Excel Discussion (Misc queries) | |||
How do I delete the page watermark in the page break preview? | Excel Discussion (Misc queries) | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
Excel page break preview | Excel Discussion (Misc queries) | |||
page break preview | Excel Discussion (Misc queries) |