Is there a way to freeze both a row and a column? That way as I scroll right
and down Row 1 and Coumn A will always show? Thanks for your help!

Click in cell B2, then select Window|Freeze Panes.
--
** John C **
Please remember, if your question is answered, to check the YES box below.
It helps everyone.


"jordanpcpre" wrote:

Is there a way to freeze both a row and a column? That way as I scroll right
and down Row 1 and Coumn A will always show? Thanks for your help!

I am trying to freeze 2 panes... one limits me to go further up (which I can
do)
and the other limits me to go further up "at another lower row".

So there will be 3 windows in the excel sheet. The top window is frozen, the
middle window I can only scroll up and down until I hit the frozen pane of
upper limit and lower limit, and the bottom window can go as low as row 65536
and it can scroll up to the 2nd pane row (where ever it is) .

Is there anyway to do this?

thanks you

"John C" wrote:

Click in cell B2, then select Window|Freeze Panes.
--
** John C **
Please remember, if your question is answered, to check the YES box below.
It helps everyone.


"jordanpcpre" wrote:

Is there a way to freeze both a row and a column? That way as I scroll right
and down Row 1 and Coumn A will always show? Thanks for your help!

please read again.... this is not what I want...

but someone else told me that what I want is not doable... so thats fine.

thanks again

"its really good" wrote:

thanks you

"John C" wrote:

Click in cell B2, then select Window|Freeze Panes.
--
** John C **
Please remember, if your question is answered, to check the YES box below.
It helps everyone.


"jordanpcpre" wrote:

Is there a way to freeze both a row and a column? That way as I scroll right
and down Row 1 and Coumn A will always show? Thanks for your help!

We have read again, and it may not be what you want, but it is exactly what
you asked for. You asked for row 1 and column A to remain visible as you
scroll right and down, and that is what John C's suggestion does.
Perhaps you could humour him and us and tell us what you *intended* to ask
for?
--
David Biddulph

"Erol" wrote in message
...
please read again.... this is not what I want...

but someone else told me that what I want is not doable... so thats fine.

thanks again

"its really good" wrote:

thanks you

"John C" wrote:

Click in cell B2, then select Window|Freeze Panes.
--
** John C **
Please remember, if your question is answered, to check the YES box
below.
It helps everyone.


"jordanpcpre" wrote:

Is there a way to freeze both a row and a column? That way as I
scroll right
and down Row 1 and Coumn A will always show? Thanks for your help!

I think I should have asked this question seperately... "jordanpcpre" asked a
question and both "John C" and "its really good" answered him properly I
guess.

I asked a different question, and this is not to place to ask I guess. It
should be a seperate question. Sorry for the confusion and thanks again.

"David Biddulph" wrote:

We have read again, and it may not be what you want, but it is exactly what
you asked for. You asked for row 1 and column A to remain visible as you
scroll right and down, and that is what John C's suggestion does.
Perhaps you could humour him and us and tell us what you *intended* to ask
for?
--
David Biddulph

"Erol" wrote in message
...
please read again.... this is not what I want...

but someone else told me that what I want is not doable... so thats fine.

thanks again

"its really good" wrote:

thanks you

"John C" wrote:

Click in cell B2, then select Window|Freeze Panes.
--
** John C **
Please remember, if your question is answered, to check the YES box
below.
It helps everyone.


"jordanpcpre" wrote:

Is there a way to freeze both a row and a column? That way as I
scroll right
and down Row 1 and Coumn A will always show? Thanks for your help!