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" wrote in message
...
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.