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

Question

How can I lock both column and rows at the same time using the 'freeze panes' in Excel? I can manage to freeze either columns or rows, but not both. I can do a similar thing with "split panes", but this isn't quite what I want.

Answer 1

To freeze rows and columns in excel,

Put the cell selector at cell B2,

Press shortcut key -> ALT + W, F, F

and the first column & first row of your sheet is freezed