Why does row one always appear at the top when page down
 

Opening sheet shows rows i to 36. When I page down the sheet shows row 1 at
the top and then rows 37 to 71. The next page down and all subsequent key
strokes will still show row one at the top of the sheet and then the next
sequence of rows.

What is wrong?

Why does row one always appear at the top when page down
 

Hi,

What is wrong?

Nothing, it's a setting called 'Freeze panes'. You didn't say which version
of Excel so for 2003

Window|Unfreeze panes

for e2007

View tab|Window group - Unfreeze panes
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Alpan" wrote:

Opening sheet shows rows i to 36. When I page down the sheet shows row 1 at
the top and then rows 37 to 71. The next page down and all subsequent key
strokes will still show row one at the top of the sheet and then the next
sequence of rows.

What is wrong?