ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   simple ? (https://www.excelbanter.com/excel-discussion-misc-queries/117129-simple.html)

Kelly********

simple ?
 
I dont no what it would be called so I cant find it

I want the top few rows and the left side colum to stay put when scrolling
the sheet
how is this done.

JMB

simple ?
 
Click Window/Freeze Panes

"Kelly********" wrote:

I dont no what it would be called so I cant find it

I want the top few rows and the left side colum to stay put when scrolling
the sheet
how is this done.


Mike Rogers

simple ?
 
Kelly********"

It is called "Freeze Panes". Everything to the left and above the selected
cell will stay in place when you scroll. So select the appropriate cell goto
windowFreeze Panes, and wallaaa you have what you want.

Mike Rogers

HTH

"Kelly********" wrote:

I dont no what it would be called so I cant find it

I want the top few rows and the left side colum to stay put when scrolling
the sheet
how is this done.



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

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