A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Using header on first page only



 
 
Thread Tools Display Modes
  #1  
Old March 22nd, 2010, 11:27 PM posted to microsoft.public.excel.newusers
PJQ
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  
Old March 23rd, 2010, 01:15 AM posted to microsoft.public.excel.newusers
Otto Moehrbach[_2_]
external usenet poster
 
Posts: 716
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  
Old March 23rd, 2010, 01:32 AM posted to microsoft.public.excel.newusers
Stan Brown
external usenet poster
 
Posts: 536
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...
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


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