Freeze panes to lock rows and columns - Excel Tips and Tricks

Learn how to freeze panes to lock rows and columns.

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.

Steps on how to Freeze First Column.
1) View --- Window --- Freeze Panes
2) Freeze First Column

Steps on how to Freeze Top Row.
1) View --- Window --- Freeze Panes
2) Freeze Top Row

Steps on how to Freeze top 2 row.
1) Select the third row.
2) View --- Window --- Freeze Panes
3) Freeze Panes

Steps on how to Freeze first 4 columns.
1) Select the 5th column.
2) View --- Window --- Freeze Panes
3) Freeze Panes

Steps on how to Freeze Panes.
1) Select cell B3
2) View --- Window --- Freeze Panes
3) Freeze Panes

Hotkey to unfreeze panes is Alt + W + F + U.

Freeze First Column,Freeze Top Row,Freeze Panes,
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,