How to Freeze Pane Rows and Columns in Excel worksheet

If you are not familar with below topics, read following lessons before continuing further.

• Row, Column and Cell in Excel worksheet
• How to Freeze Pane at Rows in Excel worksheet
• How to Freeze Pane at Columns in Excel worksheet

Sometimes you want to scroll a large worksheet by keeping an area of a worksheet visible while you navigate inside Excel worksheet. For example, you may want to see both Row Heading and Column heading of the worksheet while you scroll Excel worksheet. There is a feature in Excel called Freeze Panes to make some Rows and Columns of a worksheet always visible while you scroll Excel worksheet.

To Freeze Pane both at Row and Column, follow below steps.

Step 1 - Here in this example, I want to freeze the top-most Row and left-most Column. To freeze the top-most Row and left-most Column, I need to select the bottom corner Cell at top-most Row and left-most Column intersection (Cell Addess B2, in this example). Use the same logic to address your requirement.

Please refer below image.

Step 2 - Click "Freeze Panes" Rich menu and then select "Freeze Panes" from Excel Ribbon > "View" Tab > "Window" Group as shown below.

Step 3 - As you can see from below image, Row 1 (top-most Row) and Column A (left-most Column) are frozen and it is always visible as you scroll down or to right-side in Excel worksheet.

An animation about how to Freeze both Row and Column in an Excel worksheet is copied below.