PDA

View Full Version : Excel Question

Hybrid_11
09-22-2005, 12:45 PM
I am pretty sure its possible to lock the top row in a spreadsheet so that when scrolling down the locked cell will still appear on the top of the spreadsheet but I can't seem to remember how to do that. Does anybody know how to freeze a row?
Timer
09-22-2005, 01:31 PM
[ QUOTE ]
I am pretty sure its possible to lock the top row in a spreadsheet so that when scrolling down the locked cell will still appear on the top of the spreadsheet but I can't seem to remember how to do that. Does anybody know how to freeze a row?

[/ QUOTE ]

If the row you want to "freeze" is row one, click on the number 2 in the left hand column thereby highlighting that entire row. Then click on Window>Freeze Panes. Row one will now be locked so you can scroll.