Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default Suppress First Page Numbering

Hi folks - Is there anyway to suppress page numbering on the first page of
an Excel sheet? Thanks.

Michael


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 833
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default 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


.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you suppress the page number on page one? SUPPRESSING PAGE NUMBERS IN EXCEL Excel Discussion (Misc queries) 4 May 13th 09 01:19 PM
start page numbering from page 2 in excel swa Excel Discussion (Misc queries) 2 July 25th 07 04:53 PM
Format page numbering to be Page 1 of X Joan at UCSF Excel Discussion (Misc queries) 2 April 6th 06 03:31 AM
How do I suppress a header of footer on the first page of a docume SLF Setting up and Configuration of Excel 0 January 24th 06 06:10 PM
Suppress First Page Header Jamie Excel Worksheet Functions 7 May 13th 05 05:48 PM


All times are GMT +1. The time now is 03:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"