ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to lock a row so that it stays on top when scrolling (https://www.excelbanter.com/excel-discussion-misc-queries/31712-how-lock-row-so-stays-top-when-scrolling.html)

uturnhuggybear

how to lock a row so that it stays on top when scrolling
 
I want to create descriptions in row 1 and hen lock that row sothat as i
sroll down in the worksheet row 1 always remains visble atthe top of the
spredsheet.
this was always a simple thing todo in oder spreadsheet aplications by
simply selcting he row and chosing an option such as " lock row ".
no such option exists in excel for xp, so what do I do ?

Phil Wales

Click on a cell under the row then
Windows Split




or you could also do
Windows Freeze pane




"uturnhuggybear" wrote:

I want to create descriptions in row 1 and hen lock that row sothat as i
sroll down in the worksheet row 1 always remains visble atthe top of the
spredsheet.
this was always a simple thing todo in oder spreadsheet aplications by
simply selcting he row and chosing an option such as " lock row ".
no such option exists in excel for xp, so what do I do ?


SVC

Click in cell B1, then click Windown Freeze Panes

"uturnhuggybear" wrote:

I want to create descriptions in row 1 and hen lock that row sothat as i
sroll down in the worksheet row 1 always remains visble atthe top of the
spredsheet.
this was always a simple thing todo in oder spreadsheet aplications by
simply selcting he row and chosing an option such as " lock row ".
no such option exists in excel for xp, so what do I do ?



All times are GMT +1. The time now is 01:07 AM.

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