ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Create an always visable header row that does not move when scroll (https://www.excelbanter.com/excel-discussion-misc-queries/171393-create-always-visable-header-row-does-not-move-when-scroll.html)

Angee

Create an always visable header row that does not move when scroll
 
I don't know if this will make sense, as I have asked numerous people and no
one seems to know what I am trying to ask, but I have seen it done.

I have a header row on an Excel spreadsheet and I would like it to always be
present wether I am looking at row 2 or row 2005. I would like it to stay
visable as I scroll down the sheet. Like as if the rows were rolling under
it as I scroll down.

Thanks, any help would be greatly appreciated...this has been driving me
crazy. PS I can't spell

CLR

Create an always visable header row that does not move when scroll
 
Place your cursor in A2 and do Window FreezePanes

Vaya con Dios,
Chuck, CABGx3



"Angee" wrote:

I don't know if this will make sense, as I have asked numerous people and no
one seems to know what I am trying to ask, but I have seen it done.

I have a header row on an Excel spreadsheet and I would like it to always be
present wether I am looking at row 2 or row 2005. I would like it to stay
visable as I scroll down the sheet. Like as if the rows were rolling under
it as I scroll down.

Thanks, any help would be greatly appreciated...this has been driving me
crazy. PS I can't spell



All times are GMT +1. The time now is 02:19 PM.

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