ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do I have a heading row repeat on each page while working? (https://www.excelbanter.com/excel-worksheet-functions/174071-how-do-i-have-heading-row-repeat-each-page-while-working.html)

mephibosheth

how do I have a heading row repeat on each page while working?
 
In Excel 7 I am working on a large worksheet and need to have the first row,
which I am using as a heading to label each column, repeat at the top of each
page. I am able to do this for printing but I really need to be able to view
it while working and can't seem to find a way to accomplish this.

I am a relatively new user and help would really be appreciated.

Roger Govier[_3_]

how do I have a heading row repeat on each page while working?
 
Hi

Place cursor in cell A2WindowsFreeze Panes

--

Regards
Roger Govier

"mephibosheth" wrote in message
...
In Excel 7 I am working on a large worksheet and need to have the first
row,
which I am using as a heading to label each column, repeat at the top of
each
page. I am able to do this for printing but I really need to be able to
view
it while working and can't seem to find a way to accomplish this.

I am a relatively new user and help would really be appreciated.



mephibosheth

how do I have a heading row repeat on each page while working?
 


"Roger Govier" wrote:

Hi

Place cursor in cell A2WindowsFreeze Panes

--

Regards
Roger Govier

"mephibosheth" wrote in message
...
In Excel 7 I am working on a large worksheet and need to have the first
row,
which I am using as a heading to label each column, repeat at the top of
each
page. I am able to do this for printing but I really need to be able to
view
it while working and can't seem to find a way to accomplish this.

I am a relatively new user and help would really be appreciated.




All times are GMT +1. The time now is 08:24 AM.

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