Can you freeze in two directions in excel

T

trip_to_tokyo

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

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

David Biddulph

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to freeze panes 15
Merging from an Excel file with graphics 1
Excel Freezes 4
MS Excel Freeze panes based on selection does not work for me 4
Hide or Freeze 3
Freezing windows 2
Freeze Panes? 2
Freeze multiple rows/columns in Excel 2007 7

Top