Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
uturnhuggybear
 
Posts: n/a
Default 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 ?
  #2   Report Post  
Phil Wales
 
Posts: n/a
Default

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 ?

  #3   Report Post  
SVC
 
Posts: n/a
Default

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 ?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lock the Keyboard [email protected] Excel Discussion (Misc queries) 5 May 25th 05 06:23 PM
how to lock worksheet formatting? TANDEX Excel Worksheet Functions 3 May 11th 05 10:22 PM
How to lock worksheet formatting? TANDEX Excel Worksheet Functions 1 May 6th 05 09:36 PM
How do I lock columns together in a single row for sorting purpos. S.J.Michael Excel Discussion (Misc queries) 1 April 26th 05 02:18 AM
Lock formula?? L/P Excel Worksheet Functions 2 January 4th 05 05:49 PM


All times are GMT +1. The time now is 09:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"