Excel How to Freeze the Top Row and First Column

When we are using our worksheet, at some point, we need to see the heading of columns and the titles in the first row. We need to freeze the first column and the first row to do this. After freezing the two, you will always see the first row and the first column when you scroll down. Mostly beneficial when we are filling in the worksheet and using the titles to feel in other cells. We can also freeze other columns and rows. The procedures do not mean you only have the choice to freeze the first row and column. You can freeze the last row and the last column. For a good view, color the frozen row and column.

Here is how we do this

1. Open an excel spreadsheet.

2. Select cell B2. Navigate to the "view tab" and click on the freeze panes button at the window group. A new window will pop up and tap the freeze panes. See the screenshot.

3. The first row and column won't move when you scroll. You will see when you work on the whole worksheet. See the screenshot.

To freeze the first alone, we can do this

1. Open the excel sheet you want to work with.

2. Go to the view tab. Click freeze panes under the section named window.

A menu will pop up, click

3. After clicking, freeze the first row. The row will be frozen, and out can scroll throughout the whole worksheet. The first row will appear every place you are going to.

For the first column. Follow the same procedure and select the first column in the menu.

After that, only the first column will appear when you scroll through your worksheet.

After doing that, the border under the first row and the side of the first column will be darker. That means your column and the row have been frozen. Knowing this will help you know when you meet a worksheet with the same features.

The first procedure is fast as you will lock both of them simultaneously. You have to start with the first row as it contains the heading. To lock multiple rows and columns, you can do this.


1. To the last row you want to freeze, select the following row. Then we go to the view tab and freeze the panes. The number of rows above the row you selected will be frozen.

2. For multiple columns, start with the first column. To the right of the "last column," you need to freeze, and select the next column. Check the screenshot if you didn't get it right. Navigate to the "view tab," select freeze panes, and click freeze the panes. All left columns will be frozen. When scrolling, you will notice they don't move.

All these procedures are the same; the only difference is to select the row and the column you want to freeze. Cells from columns c to j will move when we scroll except for columns A and B. I prefer you to color them to make them attractive. Color them using format cell or change their background.