rows:
1
2
3
4
5

row 1 is locked, and when you scroll, it scrolls 2345 onwards. but not 1, its locked.

how can i replicate this? lol its at work but i want to use it for something else. ive never come across this before the stupidly simple excel spreadsheet.

help plz.

ta

edit: looks a bit like using frames in a webpage

freeze the pane

if your using 2007 its view > freeze panes (just to the right of centre) > freeze top row

edit:
if you want to freeze more then one row, you need to click 'split' first, and move the split into the correct positions, then do freeze freeze panes

http://www.techonthenet.com/excel/questions/freeze.php

heh! wow, simple. thanks!

while im on the topic of excel

i was using vlookup, but it kepts returning like, the cell above.

eg:

1 a
2 b
3 c
4 d

if i search 2 it shud return b
but no, it returned c!

or search a, returns b. it was a consist offset of +1 to the column. even though all i did was vlookup. didnt know if this freezing thing would cause this