How do you suppress the page number on page one?

[Guest]

I have a ten-page report and do not want "page 1" to print at the bottom of
page 1. I want the page numbering to begin on page two. How do you suppress
page numbers?

 

[Guest]

If you go into Headers and Footers and you can set a different header and
footer for page 1 than the rest of the worksheet. Works in Word too.

 

[Dave Peterson]

You sure that's in Excel?

If you go into Headers and Footers and you can set a different header and
footer for page 1 than the rest of the worksheet. Works in Word too.

 

[Dave Peterson]

Ron de Bruin shares some code at:
http://www.rondebruin.nl/print.htm#Header

That may help you.

 

[Sue]

For Excel 2007 you open the Page Setup box on the Page Layout tab. Under
Header/Footer tab select the box "Different first page." Then, using the
"Custom Header" button, under the "Header" tab, select the page # option.
Then, go to the "First Page Header" tab and delete the page "&[Page]." Click
"OK."

 

[Sue]

For Excel 2007 you open the Page Setup box on the Page Layout tab. Under
Header/Footer tab select the box "Different first page." Then, using the
"Custom Header" button, under the "Header" tab, select the page # option.
Then, go to the "First Page Header" tab and delete the page "&[Page]." Click
"OK."