double freeze

V

vikram

Hi
can we freeze an excel sheet row wise and as well as column wise?
mean to say that freezing the same sheet vertically and horizontally

thanks
 
F

Frank Kabel

Hi
just move the cursor for example to cell C3 and
goto 'Windows - Freeze Panes'
 
V

vikram

Hi Frank,

It is not working!

I have a freeze fter column B and now i want to freeze row 3
 
F

Frank Kabel

Hi
you have to move the cursor in the cell below the row you
want to freeze AND in the column right to the column you
want to freeze. So if you want to freeze columns A+B and
ros 1,2,3 move the cursor in cell C4 and goto 'Windows -
Freeze Panes
 
Top