Freeze Panes Using the Active Cell
When you use Freeze Panes in Excel, all the rows above the active cell and all the columns to the left of it become frozen in place. As you scroll across the spreadsheet, those cells won’t move.
Unfreeze Panes in Excel
When you freeze rows or columns in Excel and then save the file, the status of frozen panes is also saved. This means that the next time you open the sheet, those frozen rows and columns remain in place. If you don’t want those rows or columns to stay static anymore, unfreeze all rows and columns with the Unfreeze Panes command. To unlock the rows and columns so that you can scroll the entire spreadsheet:
Freeze the Left Column in Excel
You can quickly freeze the left column of a spreadsheet using the Freeze First Column command. This command freezes the left column of your spreadsheet, regardless of which cell you’ve selected. This feature is useful when the left column contains information about all of the numbers to the right of it in the sheet. To freeze the left column:
Freeze the Top Row in Excel
If you want to keep the top row visible in Excel, use the Freeze Top Row command. This command freezes only the top row of your spreadsheet, regardless of which cell you’ve selected. This is commonly used when the top row contains header information for all of the data in the spreadsheet. This immediately freezes the left column so that you can scroll the sheet to the right as far as you like, but still see the left column. To freeze the top row in a spreadsheet: This freezes the top row to scroll the sheet down as far as you like but still see the top row. If you use the Freeze Panes feature a lot in Excel, you can add all the freeze commands to the Quick Access Toolbar at the top of the Excel Ribbon.
