Home » Questions » Computers [ Ask a new question ]

Freeze row and columns in Excel (at the same time)

Freeze row and columns in Excel (at the same time)

How can I lock both column and rows at the same time using the 'freeze panes' in Excel?

Asked by: Guest | Views: 63
Total answers/comments: 2
Guest [Entry]

"Click on the cell just to the right of the column, and just below the row you want to freeze, and then select View→Window→Freeze Panes→Freeze Panes.

So, if you want to freeze row 1 and the column A, click on B2 and select View→Window→Freeze Panes→Freeze Panes.

If you want to freeze rows 1:3 and columns A:B, click on C4 and select ""Freeze Panes""."
Guest [Entry]

"Click on Cell, from where you want to freeze the pane.
Click on Split, a thick bar will appear. If you see closely you will find that it has created a pane.
In my case I selected Cell B10.
Click on Freeze pane, then again click freeze pane option. There you go you have frozen a column and row at a time."