![]() In our case, for freezing the first row and first column simultaneously, the selected cell needs to be in the second row and second column. If we want to freeze the first column, the selected cell needs to be in the second column. So if we want to freeze the first row, the selected cell needs to be in the second row. This does not include the selected cell’s row and column. ![]() The way the Freeze Panes option works is, both columns and rows will freeze based on the location of the selected cell in the worksheet.Īll columns to the left of the selected cell and all rows above the selected cell will become frozen. In this method, we will look at the steps needed for freezing both the top row and the first column.Īs an example, we will freeze the first row and first column of the following dataset which we have used in the previous method as well. To use this, select any cell in the worksheet and then press these keys one after the other How to Freeze the Top Row and First Column Pro Tip: You can also use the keyboard shortcut ALT + W + F + C to freeze the first column. ![]() So in this method, we have seen how to freeze the first column using the Freeze Panes option. As you scroll to the right, the first column will remain in place and in view.
0 Comments
Leave a Reply. |