badpr.blogg.se

Method 1 freezes only the top row, and Method 2 freezes only the first column. In conclusion, we have seen four different methods to freeze rows and columns in Excel. Note: Freeze Panes is a worksheet-level option, which means that it will only be applied to the active worksheet and will not impact the other worksheets in the workbook No matter what rows or columns you have frozen in your worksheet, the above steps will instantly unfreeze everything. From the drop-down options that appears, click on the Freeze Panes option.To use this, select the cell in the worksheet and then press these keys one after the other How to Unfreeze Rows and Columns in Excelįreeze panes options work as a toggle, so when you use it once, it is going to freeze the rows/columns, and when you use it again, it is going to unfreeze them.īelow are the steps to unfreeze rows and columns in Excel: Pro Tip: You can also use the keyboard shortcut ALT + W + F + F to freeze the rows above the selected cells and columns to the left of the selected cell. 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.