![]() |
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 ? |
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 ? |
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