Prev: Cell fill color in linked cells?
Next: Vlookup
From: Alpan on 11 May 2010 16:37
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?
From: Mike H on 11 May 2010 16:43
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?
 | 
Pages: 1
Prev: Cell fill color in linked cells?
Next: Vlookup