Freezing panes--splitting spreadsheet into quarters

I am working on an excel spreadsheet and i'm trying to freeze the top pane of
it and when I try to do so it keeps splitting the entire sheet into quarters.
How do I fix this?

Click on the row below the one you're trying to freeze - so if you're
trying to freeze row 1, click on row 2 and freeze the pane.

I did do that and it splits the entire spreadsheet into quarters.

"Nick Dangr" wrote:

> Click on the row below the one you're trying to freeze - so if you're
> trying to freeze row 1, click on row 2 and freeze the pane.
>
>

I'm not sure why its doing that, then... the only time I've seen it
split the screen into quadrants is when I tried to freeze the pane by
clicking on row 1.

Sorry :-/

Everything is in relation to the *Screen View*.

That means, what is visible (displayed) on your screen at the time that you
invoke Freeze Panes..

On a New sheet, A1 is top left.
So, we name the topmost, leftmost cell as the cell in the *A1 position*.
If you scroll down 1 row, A2 is in the *A1 position*.

*NEVER* invoke FP while you have the cell in the A1 position selected, no
matter what cell it actually is.

Check out this old post for some more info on FP:

http://tinyurl.com/2qdzt


--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Mary" <Mary@discussions.microsoft.com> wrote in message
news:5C04714C-01CA-4459-BCF9-510D8B7EA9DE@microsoft.com...
> I did do that and it splits the entire spreadsheet into quarters.
>
> "Nick Dangr" wrote:
>
> > Click on the row below the one you're trying to freeze - so if you're
> > trying to freeze row 1, click on row 2 and freeze the pane.
> >
> >