Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
PJQ PJQ is offline
external usenet poster
 
Posts: 1
Default Using header on first page only

I am creating a three page report with dollar amount on each line. I want
the total of amount entered by each name to appear on page three. My problem
is the fact that the header I want to appear on the first page is printing on
all three pages--I just want it to print on first page only. I am using
Microsoftword 2007 & excel 2007.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1,071
Default Using header on first page only

Go to Page Setup. In the Sheet tab, you have the upper rows set to repeat
on each sheet. Clear that. HTH Otto

"PJQ" wrote in message
...
I am creating a three page report with dollar amount on each line. I want
the total of amount entered by each name to appear on page three. My
problem
is the fact that the header I want to appear on the first page is printing
on
all three pages--I just want it to print on first page only. I am using
Microsoftword 2007 & excel 2007.


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 524
Default Using header on first page only

Mon, 22 Mar 2010 16:27:01 -0700 from PJQ
:

I am creating a three page report with dollar amount on each line. I want
the total of amount entered by each name to appear on page three. My problem
is the fact that the header I want to appear on the first page is printing on
all three pages--I just want it to print on first page only. I am using
Microsoftword 2007 & excel 2007.


Easiest way is just to put the header within the worksheet.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...
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 I PUT A DIFFERENT HEADER ON EACH PAGE? suicidecity Excel Discussion (Misc queries) 1 October 9th 08 11:33 PM
Omit header from first page without embedding header in code ibvalentine Excel Worksheet Functions 6 August 28th 07 05:10 AM
Get header only on first page of multi page excel file betwms Excel Discussion (Misc queries) 3 March 29th 06 05:47 PM
Page Header jake1729 Excel Worksheet Functions 3 September 16th 05 03:28 AM
header and footer on every page except the first page? marany Excel Discussion (Misc queries) 1 April 18th 05 06:12 PM


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

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

About Us

"It's about Microsoft Excel"