Can you freeze in two directions in excel
 

Can you freeze in two direction in excel, along rows and colums?

Can you freeze in two directions in excel
 

EXCEL 2007

Yes, try this.

Click in cell B2 then View / Window group / Freeze Panes / Freeze Panes

Now scroll around and you should find that column A is always present as is
row 1.

If my comments have helped please hit Yes.



"Amber" wrote:

Can you freeze in two direction in excel, along rows and colums?

Can you freeze in two directions in excel
 

sure. select the cell to the right and below of where you want to freeze,
then pick "freeze pane"

--
Best Regards,

Luke M
"Amber" wrote in message
...
Can you freeze in two direction in excel, along rows and colums?

Can you freeze in two directions in excel
 

Yes. It will freeze everything above or to the left of the selected cell.
If you click in B3, for example, it will freeze rows 1 & 2, and column A.
--
David Biddulph


"Amber" wrote in message
...
Can you freeze in two direction in excel, along rows and colums?