On the View tab, in the Window group, click Freeze Panes.
Besides, where is freeze pane Excel 2021?
Click on the “View” tab at the top and select the “Freeze Panes” command. From the resulting dropdown list, select the “Freeze Panes” command. In recent MS Excel versions, this option takes the top spot on the dropdown list.
Herein, how do I freeze a worksheet in Excel? >Freeze Worksheets Manually>
- First, select a cell, row or column, below and to the right of the area that you want frozen. …
- On the Excel Ribbon, click the View tab.
- Click the Freeze Panes command.
- Click Freeze Panes, to freeze at the selected location – OR, choose a command to freeze the first row or first column.
Consequently, how do you unfreeze panes in an Excel spreadsheet?
To unfreeze panes:
To unfreeze rows or columns, click the Freeze Panes command, then select Unfreeze Panes from the drop-down menu.