#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DRKENNE
 
Posts: n/a
Default Worksheet header

If my work sheet has informationin the first row (heading), how do I carry it
over to be at the top of each worksheet if the worksheet has multiple pages
when I print?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul B
 
Posts: n/a
Default Worksheet header

Drkenne, multiple pages in the same worksheet, file, page set up, sheet,
rows to repeat at top put $1:$1 or click in row one of the sheet, OK
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"DRKENNE" wrote in message
...
If my work sheet has informationin the first row (heading), how do I carry
it
over to be at the top of each worksheet if the worksheet has multiple
pages
when I print?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default Worksheet header

FilePage setupSheet tab, Rows to repeat at top

--
Kind regards,

Niek Otten

"DRKENNE" wrote in message ...
If my work sheet has informationin the first row (heading), how do I carry it
over to be at the top of each worksheet if the worksheet has multiple pages
when I print?



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
Populating worksheet via a drop down list ! kuansheng Excel Worksheet Functions 4 February 14th 06 05:48 AM
I want a title to print on every page of a worksheet; not a header DeltaPearl Excel Discussion (Misc queries) 2 February 2nd 06 05:43 PM
Search/Match between 2 x separate Worksheets and populate result in third worksheet Alan Bartley Excel Discussion (Misc queries) 1 April 11th 05 05:21 AM
Copy from worksheet to another x times Union70 Excel Discussion (Misc queries) 0 March 7th 05 09:03 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM


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