how to lock a row so that it stays on top when scrolling

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to fix the top-most 4 rows when scrolling? 1
How do I lock the top 2 rows (headings) so that they are always displayed when moving around the spr 1
Freeze the side column/top row & scroll others 2
Locking in a Snag-it(jpg) into a Cell so it stays with that row 1
How to make the scrolling not include the top rows of the sheet 3
How do I lock a row in place so that when I sort the worksheet, t. 1
How do you lock rows for scrolling ? 2
How do I lock cells so when I scroll they stay? 1

Back
Top