![how to freeze first two rows in excel how to freeze first two rows in excel](https://www.shorttutorials.com/msexcel-2013/images/unfreeze-panes-ms-excel-2013.png)
When you activate the freeze of multiple rows, they will always remain at the top when scrolling through the document. Click the “ Freeze Panes” tool and select the topmost option.
#How to freeze first two rows in excel software#
With this action, you will indicate the software a border to which you need to freeze the rows. Tap on the cell below the rows you want to freeze.
#How to freeze first two rows in excel how to#
So how to freeze certain rows in Excel so that they don’t go away while scrolling? The program allows you to “freeze” not only the top row but also any other rows at a user’s discretion.
![how to freeze first two rows in excel how to freeze first two rows in excel](https://cdn4syt-solveyourtech.netdna-ssl.com/wp-content/uploads/2015/10/excel-2013-freeze-multiple-rows-3.jpg)
Excel knows itself which row to be frozen.Īfter that, you can scroll the document down to infinity, but the top row will always be visible since it has been frozen. There is no need to select the row before this action.
![how to freeze first two rows in excel how to freeze first two rows in excel](https://www.tech-recipes.com/wp-content/uploads/2016/02/excel-freeze-row-and-column.png)
To freeze multiple columns, select the column to the right of the last column you want to lock (freeze) when you scroll. Now, when you scroll horizontally, the ‘First Name’ column is frozen and remains visible. You can freeze the first column of the sheet, the same way you can freeze the first row, except this time, you have to select the ‘Freeze First Column’ instead of the Freeze Top Row option in the ‘Freeze Panes’ menu.
![how to freeze first two rows in excel how to freeze first two rows in excel](https://www.teachexcel.com/images/uploads/0f8a114f9e1d34b1f5bcb77fce8c59b1.jpg)
In the example, we froze the first four rows and a line separates the frozen rows and unfrozen rows. To freeze rows of your choice, first, select the row below the last row that you want to freeze, then go to the ‘View’ tab, and select the ‘Freeze Panes’ option in the Freeze Panes drop-down menu. To do that, head to the ‘View’ tab and click ‘Freeze Panes’ in the Ribbon, and select the ‘Freeze Top Row’ option.Īs you can see, the header in the following example is still visible when I scroll down to row 14.Įxcel allows you to freeze not just one row but as many rows as possible. When you scrolling down the worksheet, you might want to keep your eye on the top row which contains the header of the sheet. You can do that by the ‘Freeze Panes’ feature in Excel that keeps specific rows or columns visible when you scroll through in the worksheet. If you have a large amount of data in excel and when scrolling down or scrolling horizontally, you don’t want to lose sight of a certain row or column. For instance, if the first column in your worksheet contains names, you might want to freeze that column to make sure that the names remain visible as you scroll through (horizontally) in your worksheet.