Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
mad mad is offline
external usenet poster
 
Posts: 5
Default how do I maintain the first line in each page to be pringted?

I'm looking to keep the first line as a header in each printed page.
I've seen it done, but can't remember how to do it... help?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default how do I maintain the first line in each page to be pringted?

Select the sheet, then
File | Page Setup | Sheets tab
There you will find a box with "Rows to Repeat at top" and you can identify
the row/rows you wish to show up on each additional page printed from that
sheet.

If you want a true header that will be the same for all pages printed on all
sheets;
File | Page Setup | Header/Footer tab

Good luck.

"mad" wrote:

I'm looking to keep the first line as a header in each printed page.
I've seen it done, but can't remember how to do it... help?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 196
Default how do I maintain the first line in each page to be pringted?

hi

FilePageSetupSheet tab and fill in "Rows to repeat at top"

Hope this helps!

Richard

mad wrote:
I'm looking to keep the first line as a header in each printed page.
I've seen it done, but can't remember how to do it... help?


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
sheet line bottom of page missing Jerry Excel Worksheet Functions 1 April 26th 06 03:45 AM
How can I remove a verticle page break that is a dashed line. MGB Excel Discussion (Misc queries) 2 March 16th 06 11:04 PM
Page Break Problem top.jimmy Excel Worksheet Functions 6 February 27th 06 10:21 PM
I need to print cells under the orginal line instead of page break InvoCare Excel Discussion (Misc queries) 1 August 29th 05 08:32 PM
excel 2003 page numbering art Excel Worksheet Functions 3 December 8th 04 10:49 PM


All times are GMT +1. The time now is 03:44 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"