ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to make the scrolling not include the top rows of the sheet (https://www.excelbanter.com/excel-discussion-misc-queries/152700-how-make-scrolling-not-include-top-rows-sheet.html)

Magrano

How to make the scrolling not include the top rows of the sheet
 
I have seen in other excel document people managed that the top rows is not
included when scrolling instead they stay at the top. How do I do this.

FSt1

How to make the scrolling not include the top rows of the sheet
 
hi
on the menu bar....
Windowfreeze panes.
you can freeze rows and/or columns

Regards
FSt1

"Magrano" wrote:

I have seen in other excel document people managed that the top rows is not
included when scrolling instead they stay at the top. How do I do this.


ed

How to make the scrolling not include the top rows of the sheet
 
On Aug 2, 2:06 am, FSt1 wrote:
hi
on the menu bar....
Windowfreeze panes.
you can freeze rows and/or columns

Regards
FSt1



"Magrano" wrote:
I have seen in other excel document people managed that the top rows is not
included when scrolling instead they stay at the top. How do I do this.- Hide quoted text -


- Show quoted text -


Or, Just split the screen from that same Windows Menu. If split you
can move the divider around. In either case you can do just columns,
just rows, or both.

ed


challa prabhu

How to make the scrolling not include the top rows of the sheet
 
Hi,

To freeze the window pane, just click the second rows below the header and
click Freeze panes from the Window menu.

Challa Prabhu

"Magrano" wrote:

I have seen in other excel document people managed that the top rows is not
included when scrolling instead they stay at the top. How do I do this.



All times are GMT +1. The time now is 07:11 PM.

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