How to freeze one column vertically, one horizontal in same sprdsh
 

Is it possible to freeze a column vertically and one horizontally in the same
spreadsheet?

How to freeze one column vertically, one horizontal in same sprdsh
 

Do you mean other than Row 1 and Column 1? If that is what you meant, then
the answer is "no".

--
Rick (MVP - Excel)



"sweaver" wrote in message
...
Is it possible to freeze a column vertically and one horizontally in the
same
spreadsheet?

How to freeze one column vertically, one horizontal in same sprdsh
 

What cell is below the row you want frozen and to the right of the column you
want frozen. Find that intersection cell and place your cursor in it. Then
go to Windows, Freeze Panes.

"sweaver" wrote:

Is it possible to freeze a column vertically and one horizontally in the same
spreadsheet?

How to freeze one column vertically, one horizontal in same sprdsh
 

On 5/4/2010 3:08 PM, Nadine wrote:
What cell is below the row you want frozen and to the right of the column you
want frozen. Find that intersection cell and place your cursor in it. Then
go to Windows, Freeze Panes.

"sweaver" wrote:

Is it possible to freeze a column vertically and one horizontally in the same
spreadsheet?

This approach will freeze ALL the rows above and ALL the columns to the
left of the selected cell, not just one row and column.

Bill

How to freeze one column vertically, one horizontal in same sp
 

That was what I took her question to mean she wanted. Sorry if she didn't
want this.

"Billns" wrote:

On 5/4/2010 3:08 PM, Nadine wrote:
What cell is below the row you want frozen and to the right of the column you
want frozen. Find that intersection cell and place your cursor in it. Then
go to Windows, Freeze Panes.

"sweaver" wrote:

Is it possible to freeze a column vertically and one horizontally in the same
spreadsheet?

This approach will freeze ALL the rows above and ALL the columns to the
left of the selected cell, not just one row and column.

Bill
.