How do you unfreeze a pane in Excel?

How do you unfreeze a pane in Excel?

You’re scrolling down your worksheet (or scrolling to the side), but part of it is frozen in place. This is probably because at some point you decided to freeze the panes. To fix this, click View > Window > Unfreeze Panes.

How do I unfreeze my Excel 2020?

Unfreeze Panes

1. Select any cell on the the worksheet.
2. On the Excel Ribbon, click the View tab.
3. If there is an Unfreeze Pane command in the drop down list, click that, to unfreeze the locked sections.

What does freezing a pane do in Excel?

When you freeze panes, Excel keeps specific rows or columns visible when you scroll in the worksheet. For example, if the first row in your spreadsheet contains labels, you might freeze that row to make sure that the column labels remain visible as you scroll down in your spreadsheet.

How do you stop Excel from not responding?

Excel not responding, hangs, freezes or stops working

1. Start Excel in safe mode.
2. Install the latest updates.
3. Check to make sure Excel is not in use by another process.
4. Investigate possible issues with add-ins.
5. Investigate Excel file details and contents.
6. Check whether your file is being generated by a third party.

Where is the freeze pane in Excel?

Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Select View > Freeze Panes > Freeze Panes.

What is freeze in spreadsheet?

The Excel Freeze Panes tool allows you to lock your column and/or row headings so that, when you scroll down or over to view the rest of your sheet, the first column and/or top row remain on the screen.

How do I unfreeze my data?

To unfreeze panes: If you want to select a different view option, you may first need to reset the spreadsheet by unfreezing panes. To unfreeze rows or columns, click the Freeze Panes command, then select Unfreeze Panes from the drop-down menu.

Why won’t freeze panes work in Excel?

Freeze Panes not working. If the Freeze Panes button is disabled (greyed out) in your worksheet, most likely it’s because of the following reasons: You are in cell editing mode, for example entering a formula or editing data in a cell. To exit cell editing mode, press the Enter or Esc key. Your worksheet is protected.

How do you freeze multiple areas in Excel?

Freeze Panes in Excel: Instructions. To freeze panes in both columns and rows in a worksheet, select the cell below the row and to the right of the column to freeze. Click the “View” tab in the Ribbon. Then click the “Freeze Panes” button in the “Window” button group. Then choose the “Freeze Panes” command from the drop-down menu.

How to freeze more than one pane?

Open your Excel sheet. Click on the option ‘ view. ‘ Then choose the option ‘ Freeze panes ‘

How do you freeze different rows in Excel?

To freeze certain rows in Excel, first scroll to the first row to be frozen (the first row you want to freeze needs to be the first row visible on screen), now select all the rows you want to freeze and click the Freeze Panes button. Do the same if you wish to freeze certain columns.