You cannot, for instance, freeze the third column and nothing else around it.Äownload the spreadsheet that accompanies this tutorial to see this feature in action in Excel. You can only freeze the rows starting from the top and the columns starting from the left. Go to the View tab and click Freeze Panes and, if there are any frozen panes in the worksheet, you will see the first choice in the list titled Unfreeze Panes, click that. Unfreeze/Unlock Columns and Rows in Excel On the worksheet, do one of the following: To lock rows, select the row below where you want the split to appear, 2.
![how can i freeze first two rows in excel how can i freeze first two rows in excel](https://static.wixstatic.com/media/9d7f1e_13505df8abd84e0dbb31c323e7d5bfc8~mv2.png)
Using this method, you can freeze the first two rows, the first two columns, the first two rows and the first 2 columns at the same time, basically whatever you want. Now, I can scroll down and to the right and the first column and row will remain in place.
![how can i freeze first two rows in excel how can i freeze first two rows in excel](https://i0.wp.com/www.alphr.com/wp-content/uploads/2021/04/1-115.png)
Choose the Freeze Panes option from the menu. The first column now stays the same when I scroll to the right or left. Select a cell in the first column directly below the rows you want to freeze. If I chose to freeze the first column, then it would look like this: Now, when I scroll, you can see that the first row never changes: I will select Freeze Top Row to lock the first row in place. From the drop down menu select if you want the header row, the first row of data, or the header column, the first column of data to be frozen.Go to the View tab and click the Freeze Panes button.Select the third row, immediately below the two rows you wish to freeze in place. Notes Steps to Lock Rows/Columns in Excel If you find yourself needing to freeze the top two rows of your spreadsheet so they stay in place while you scroll through your document, simply follow these steps: 1. Unfreeze/Unlock Columns and Rows in Excel
![how can i freeze first two rows in excel how can i freeze first two rows in excel](https://i1.wp.com/www.exceltrick.com/wp-content/uploads/2018/10/11.png)
This allows you to keep header rows and columns in place so you can tell what each column or row is for no matter where you are in the worksheet. Click the Freeze Panes box, then choose Freeze Panes from the list. Prevent specific rows or columns from moving when you scroll through a spreadsheet in Excel. Click on the first cell in the column below the rows you want to freeze.