ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I treat row 1 in my worksheet as a header for each page? (https://www.excelbanter.com/excel-worksheet-functions/126465-how-do-i-treat-row-1-my-worksheet-header-each-page.html)

cfcoyne

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.

Don Guillett

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.




cfcoyne

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.





Don Guillett

How do I treat row 1 in my worksheet as a header for each page
 
It's only easy if you know how. Hard if you don't

--
Don Guillett
SalesAid Software

"cfcoyne" wrote in message
...
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.








All times are GMT +1. The time now is 06:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com