Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default How do I treat row 1 in my worksheet as a header for each page?

I have a large database worksheet with name, address, phone, etc on row 1. I
want to automatically have this row duplicated at the top of each page. How
do I do this?

Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,124
Default How do I treat row 1 in my worksheet as a header for each page?


filepage setupsheet
--
Don Guillett
SalesAid Software

"cfcoyne" wrote in message
...
I have a large database worksheet with name, address, phone, etc on row 1.
I
want to automatically have this row duplicated at the top of each page.
How
do I do this?

Thanks.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default How do I treat row 1 in my worksheet as a header for each page

Thanks Don. I'm almost embarrassed it was that easy!

"Don Guillett" wrote:


filepage setupsheet
--
Don Guillett
SalesAid Software

"cfcoyne" wrote in message
...
I have a large database worksheet with name, address, phone, etc on row 1.
I
want to automatically have this row duplicated at the top of each page.
How
do I do this?

Thanks.




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
Problem with Header in Excel worksheet Roger Thompson Excel Discussion (Misc queries) 3 November 21st 06 11:39 PM
why would page 1 of an excel worksheet print smaller of page 2 if. hisdrama pest Excel Discussion (Misc queries) 1 January 10th 05 07:14 PM
Default header in Excel under page set-up Melanie Excel Discussion (Misc queries) 2 December 15th 04 01:37 AM
How do I copy page setup from one worksheet & paste into new shee. Rasc0 Excel Discussion (Misc queries) 2 December 1st 04 10:12 PM


All times are GMT +1. The time now is 04:05 AM.

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"