View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected] tewksbum@gmail.com is offline
external usenet poster
 
Posts: 1
Default Page Numbers in footer

On Dec 28 2007, 1:40*pm, "Jim Rech" wrote:
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?


On a like topic, does anyone know how when printing a multi-page
workbook I can get the page count to reset for each worksheet?

For example, my workbook may contain 5 worksheet that each are 10
pages long. When I print the workbook it prints them 1 to 50. What I
would like is for each worksheet to be numbered 1 to 10.