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

"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""."

"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."