How print pages without including the first sheet?

[Mark F]

How can I number pages without including the pages from the first
sheet in the page count?
first or first few
pages?

In particular:
There are many sheets in the "book".
The first sheet, which may print on more than
one page, is a "summary" that should not be
included in the footers.

The number of pages in the printout for the
sheets varies from month to month.

I want the footers of the printed pages to
include a page number that starts at 1 for the
first page of the second sheet.

The &[page] construct in the footer doesn't work directly.

Thank you.

 

[Gord Dibben]

With sheet1 having a variable number of pages I would suggest two print
jobs.

First job sheet1 with no page numbers...............second with all sheets
but sheet1 with page numbers.


Gord Dibben MS Excel MVP

 

[Mark F]

With sheet1 having a variable number of pages I would suggest two print
jobs.

First job sheet1 with no page numbers...............second with all sheets
but sheet1 with page numbers.

We wound up doing something like that.

However it seems like there might
be a way to it by using a custom footer for sheet1 without a page
number and also setting the value of &[Page] to an appropriate
negative number by going to "View" > "Header and Footer..."
and then in "Page Setup" tab "Page" "First page number".

I'd have to see how many pages there were on sheet1, but that number
will only change once a year.

Gord Dibben MS Excel MVP

How can I number pages without including the pages from the first
sheet in the page count?
first or first few
pages?

In particular:
There are many sheets in the "book".
The first sheet, which may print on more than
one page, is a "summary" that should not be
included in the footers.

The number of pages in the printout for the
sheets varies from month to month.

I want the footers of the printed pages to
include a page number that starts at 1 for the
first page of the second sheet.

The &[page] construct in the footer doesn't work directly.

Thank you.

 

[Mark F]

With sheet1 having a variable number of pages I would suggest two print
jobs.

First job sheet1 with no page numbers...............second with all sheets
but sheet1 with page numbers.

We wound up doing something like that.

However it seems like there might
be a way to it by using a custom footer for sheet1 without a page
number and also setting the value of &[Page] to an appropriate
negative number by going to "View" > "Header and Footer..."
and then in "Page Setup" tab "Page" "First page number".

After searching around for about the 20th time I tried using Google
to look for
excel "&[Page]"
and the first entry:

http://heykevinle.blogspot.com/2007/06/excel-custom-page-numbering_22.html
showed that the syntax
&Page+{number}&
was valid in the footer, which allows me to do what I want.

So, my new question is:
Where can I find the syntax and semantics for expressions available
for use in page headers/footers?

I'd have to see how many pages there were on sheet1, but that number
will only change once a year.

Gord Dibben MS Excel MVP

How can I number pages without including the pages from the first
sheet in the page count?
first or first few
pages?

In particular:
There are many sheets in the "book".
The first sheet, which may print on more than
one page, is a "summary" that should not be
included in the footers.

The number of pages in the printout for the
sheets varies from month to month.

I want the footers of the printed pages to
include a page number that starts at 1 for the
first page of the second sheet.

The &[page] construct in the footer doesn't work directly.

Thank you.