Freeze panes to lock rows and columns in Excel

Hi Friend, while working on excel, sometimes you may need lock top rows and left columns and view other data while scrolling the excel sheet.

In simple words “To keep an area of a worksheet visible while you scroll to another area of the same worksheet,”

To freeze the top row and the first column at the same time, click the View tab > Freeze Panes > Freeze Panes.

To freeze the leftmost column alone, click the View tab > Freeze Panes > Freeze First Column.

To freeze the top row alone, click the View tab > Freeze Panes > Freeze Top Row.

To Un-Freeze the freeze Row or columns, click the View tab > Freeze Panes > Unfreeze Panes.