View Single Post
  #5   Report Post  
RagDyer
 
Posts: n/a
Default Freezing panes--splitting spreadsheet into quarters

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.