ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do you suppress the page number on page one? (https://www.excelbanter.com/excel-discussion-misc-queries/70304-how-do-you-suppress-page-number-page-one.html)

SUPPRESSING PAGE NUMBERS IN EXCEL

How do you suppress the page number on page one?
 
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?

sp3cialist

How do you suppress the page number on page one?
 
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.

"SUPPRESSING PAGE NUMBERS IN EXCEL" wrote:

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?


Dave Peterson

How do you suppress the page number on page one?
 
You sure that's in Excel?

sp3cialist wrote:

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.

"SUPPRESSING PAGE NUMBERS IN EXCEL" wrote:

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?


--

Dave Peterson

Dave Peterson

How do you suppress the page number on page one?
 
Ron de Bruin shares some code at:
http://www.rondebruin.nl/print.htm#Header

That may help you.

SUPPRESSING PAGE NUMBERS IN EXCEL wrote:

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?


--

Dave Peterson

Sue

How do you suppress the page number on page one?
 
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."

"SUPPRESSING PAGE NUMBERS IN EXCEL" wrote:

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?



All times are GMT +1. The time now is 09:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com