If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Suppress First Page Numbering
Hi folks - Is there anyway to suppress page numbering on the first page of
an Excel sheet? Thanks. Michael |
#2
|
|||
|
|||
Suppress First Page Numbering
Michael, unfortunately there is no way.
-- Jacob (MVP - Excel) "Michael" wrote: Hi folks - Is there anyway to suppress page numbering on the first page of an Excel sheet? Thanks. Michael . |
#3
|
|||
|
|||
Suppress First Page Numbering
EXCEL 2007
This assumes that you already have page numbers set up in your Workbook. Take the following actions to suppress page numbering from the first page:- 1. Insert / Text group / Header & Footer / 2. Header & Footer Tools should now appear with the Design contextual tab highlighted. 3. In the Options group click in:- Different First Page If you now Print Preview your Workbook you will find that there are no page numbers on the first page. If my comments have helped please hit Yes. Thanks. "Michael" wrote: Hi folks - Is there anyway to suppress page numbering on the first page of an Excel sheet? Thanks. Michael . |
#4
|
|||
|
|||
Suppress First Page Numbering
Michael; I should have added the version I use which is XL2003. For a VBA
solution; check out the below link by Ron de Bruin http://www.rondebruin.nl/print.htm#not -- Jacob (MVP - Excel) "Jacob Skaria" wrote: Michael, unfortunately there is no way. -- Jacob (MVP - Excel) "Michael" wrote: Hi folks - Is there anyway to suppress page numbering on the first page of an Excel sheet? Thanks. Michael . |
#5
|
|||
|
|||
Suppress First Page Numbering
Thanks to everyone. I was aware of the feature in 2007. I neglected to
mention that I use 2003. My bad. Thanks. Michael "trip_to_tokyo" wrote in message ... EXCEL 2007 This assumes that you already have page numbers set up in your Workbook. Take the following actions to suppress page numbering from the first page:- 1. Insert / Text group / Header & Footer / 2. Header & Footer Tools should now appear with the Design contextual tab highlighted. 3. In the Options group click in:- Different First Page If you now Print Preview your Workbook you will find that there are no page numbers on the first page. If my comments have helped please hit Yes. Thanks. "Michael" wrote: Hi folks - Is there anyway to suppress page numbering on the first page of an Excel sheet? Thanks. Michael . |
Thread Tools | |
Display Modes | |
|
|