how to freeze first two rows in excel 2016

There are times that the row headers and the column headers will not be the top row or the first column of a worksheet. At this time, you can see the first row and column in the worksheet all the time. Next you can see grey lines in the bottom of the first row and the right of the first column.

In the drop-down list, choose the option “Freeze Panes”.

And then click the button “Freeze Pane” in the toolbar.

In this worksheet, we will click the cell B2.

Click the leading cell except for the cell in the first row or column.

You need to freeze both the first row and the first column. However, sometimes you need to know both the row header and the column header. When you move rightwards, you can always see the first column in the worksheet. Then you will see a grey line in the left of the first column.

And then choose the option “Freeze First Column” in the drop-down list.

Click the button “Freeze Panes” in the toolbar.

In this part, you need to freeze the first column. When you scroll the worksheet and move downwards, you will find that the top row is always visible. Then you will see a grey line under the first row in the worksheet. In this step, choose the second option “Freeze Top Row” in the menu.

After that, you will see a drop-down list.

And then click the button “Freeze Panes” in the toolbar.

In the worksheet, click the tab “View” in the ribbon.We will use this worksheet in the image below as an example. We have divided into several different small parts. It is a little different for freezing rows or freezing columns. Thereby, you can follow the steps below and see how to freeze panes.

If you need to know the headers of a certain cell, you need to scroll back. When you move downwards or move rightwards, you will not be able to see the row header or the column header. But you could perhaps encounter with such an issue. It is needless to say that you will surely view data in an Excel worksheet by scrolling the worksheet. In this article, we will show you how to freeze panes so that you can view data more effortlessly. When there are large data sets in your Excel, you will spend a lot of time on scrolling your worksheet.

How to freeze first two rows in excel 2016