Blank Page and Footer

B

BristolBreeze

Hi,

I have created an Excel template, with footer, for statements. As each
statement is of 4 to 5 pages I have decided to print them both sided.
The only problem I am having now is that I want to separate the first
page, which is a letter, from the subsequent pages.

I tried inserting a blank page (extra blank lines) in the template but
still getting footer on page 2.

Is there any way I can suppress footer on page 2

or

Start printing from page 3 (but in this case page number and total
pages should be proper. I mean total pages should not include page 1
and the blank page 2)

or

any other way to achieve this.

Thanks & Regards,
Prasad
 
S

Stephen

BristolBreeze said:
Hi,

I have created an Excel template, with footer, for statements. As each
statement is of 4 to 5 pages I have decided to print them both sided.
The only problem I am having now is that I want to separate the first
page, which is a letter, from the subsequent pages.

I tried inserting a blank page (extra blank lines) in the template but
still getting footer on page 2.

Is there any way I can suppress footer on page 2

or

Start printing from page 3 (but in this case page number and total
pages should be proper. I mean total pages should not include page 1
and the blank page 2)

or

any other way to achieve this.

Thanks & Regards,
Prasad
Click to expand...

Why not put page 1 on a separate worksheet?
 
D

Dave Peterson

I would use your 2nd suggestion. In fact, I'd record a macro when I did all
that so that I could just rerun that macro when I needed to do it again.
 
Top