Can you freeze in two direction in excel, along rows and colums?
T trip_to_tokyo May 13, 2010 #2 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.
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.
L Luke M May 13, 2010 #3 sure. select the cell to the right and below of where you want to freeze, then pick "freeze pane"
D David Biddulph May 13, 2010 #4 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.
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.
