Learn how to freeze panes to lock rows and columns.<br /><br />Go to the View tab to Freeze Panes to lock select rows and columns in place or Split Panes to create two windows of the same worksheet if you want to keep a portion of a worksheet visible while scrolling to another portion of the worksheet.<br /><br />Steps on how to Freeze First Column.<br />1) View --- Window --- Freeze Panes<br />2) Freeze First Column<br /><br />Steps on how to Freeze Top Row.<br />1) View --- Window --- Freeze Panes<br />2) Freeze Top Row<br /><br />Steps on how to Freeze top 2 row.<br />1) Select the third row.<br />2) View --- Window --- Freeze Panes<br />3) Freeze Panes<br /><br />Steps on how to Freeze first 4 columns.<br />1) Select the 5th column.<br />2) View --- Window --- Freeze Panes<br />3) Freeze Panes<br /><br />Steps on how to Freeze Panes.<br />1) Select cell B3<br />2) View --- Window --- Freeze Panes<br />3) Freeze Panes<br /><br />Hotkey to unfreeze panes is Alt + W + F + U.<br /><br />Freeze First Column,Freeze Top Row,Freeze Panes,<br />excel freeze multiple rows,excel freeze multiple columns,freeze rows and columns in excel,how to freeze 2 rows in excel,excel freeze column,how to freeze 2 columns in excel,how to freeze selected rows in excel,how to freeze top row in excel,