View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech[_2_] Jim Rech[_2_] is offline
external usenet poster
 
Posts: 533
Default Page Numbers in footer

If you group the worksheets you what to print, or select Entire Workbook
from the Print dialog, then the first sheet will set the page number for it
and all the following sheets will use the next number (as long as they are
set to "Auto" as their first page number).

--
Jim
"Sherry" wrote in message
...
|I want my first worksheet to be page 3; my second worksheet - page 4 and so
| on. In the first worksheet under Page Setup, I inserted "&[page]", then
| changed "first page number" to be 3". However, worksheet 4, begins with
page
| 1. I don't want to go to each worksheet and change the "first page
number"
| to 4, then 5, then 6.
|
| Also, I've tried selected all worksheets (using CRTL), and then changing
the
| setup but then all the worksheets have page 3 on them.
|
| Any ideas?