Freeze panes to lock rows and columns

Freezing panes in Excel allows you to keep specific rows or columns visible while you scroll through the rest of your worksheet. This is especially useful when you’re working with large datasets and want to always see the headers or important information.

Steps to Freeze Panes in Excel:

1. Freeze the Top Row:

To keep the top row visible as you scroll down:

1. Go to the View tab on the ribbon.
2. In the Window group, click Freeze Panes.
3. From the drop-down menu, select Freeze Top Row.
   • This will lock the top row, so it remains visible while you scroll through the worksheet.

2. Freeze the First Column:

To keep the first column visible as you scroll to the right:

1. Go to the View tab on the ribbon.
2. In the Window group, click Freeze Panes.
3. From the drop-down menu, select Freeze First Column.
   • This will lock the first column, so it remains visible while you scroll horizontally.

3. Freeze Both Rows and Columns (Custom Freeze):

To freeze both rows and columns, for example, the top row and the first column:

1. Select the cell below the row(s) and to the right of the column(s) you want to freeze.
   • For example, if you want to freeze Row 1 and Column A, select cell B2.
2. Go to the View tab on the ribbon.
3. In the Window group, click Freeze Panes.
4. From the drop-down menu, select Freeze Panes (this will freeze everything above and to the left of the selected cell).

4. Unfreeze Panes:

If you want to unfreeze the panes and return to the default scroll behavior:

1. Go to the View tab on the ribbon.
2. In the Window group, click Freeze Panes.
3. From the drop-down menu, select Unfreeze Panes.

Tips:

• The Freeze Panes feature locks the rows and columns based on where the selection is made. You can freeze a specific section of your worksheet based on your needs.
• Frozen panes will remain visible as you scroll, making them ideal for keeping headers or important reference data in view.

Using these methods, you can efficiently manage large datasets and ensure key information stays visible while working in Excel.