freeze
 

Hi I would like to know how can I freeze the first column and first line at
same time

I need the first line to freeze and the first colunm. But when I go to cel
1A and click freeze..it freeze 6 lines....and the screen get very limited to
navigate

thanks
Teresa

freeze
 

On Dec 19, 3:41 pm, Terry wrote:
Hi I would like to know how can I freeze the first column and first line at
same time

I need the first line to freeze and the first colunm. But when I go to cel
1A and click freeze..it freeze 6 lines....and the screen get very limited to
navigate

thanks
Teresa

You have two problems. First you probably have Windows Split set at
the 6th row, so clear any splits.
Second you must put your cursor in cell B-2 inorder to freeze column A
and row 1.

ed

freeze
 

Terry,

If you want to freeze the first row and the first column, you should be in
cell B2 when you Freeze Panes. Try that and see if it makes a difference.


"Terry" wrote:

Hi I would like to know how can I freeze the first column and first line at
same time

I need the first line to freeze and the first colunm. But when I go to cel
1A and click freeze..it freeze 6 lines....and the screen get very limited to
navigate

thanks
Teresa

freeze
 

Select B2 and WindowFreeze Panes.

The rule for freezing is.........rows above and columns left of the selected
cell will be frozen.


Gord Dibben MS Excel MVP

On Wed, 19 Dec 2007 13:41:01 -0800, Terry
wrote:

Hi I would like to know how can I freeze the first column and first line at
same time

I need the first line to freeze and the first colunm. But when I go to cel
1A and click freeze..it freeze 6 lines....and the screen get very limited to
navigate

thanks
Teresa