
Freeze panes to lock rows and columns - Microsoft Support
To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can …
Freeze panes to lock the first row or column in Excel for iOS
If you want the row and column headers always visible when you scroll through your worksheet, you can lock the top row and/or first column. Tap View > Freeze Panes, and then tap the …
Freeze panes to lock the first row or column in Excel for Mac
Lock specific rows or columns in place by freezing panes, so you can scroll through an Excel spreadsheet and still see the top row or left column. You can freeze just the top row and first …
Split panes to lock rows or columns in separate worksheet areas
Splitting a worksheet lets you see two regions at the same time in different panes by scrolling in each pane. It freezes panes while you scroll in one of the panes.
Unfreeze locked panes - Microsoft Support
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 > …
Move or scroll through a worksheet - Microsoft Support
To view all your data, you can scroll smoothly through a worksheet without snapping to the top-left cell in your display. Even if you stop scrolling partly through a row or column, Excel doesn’t …
Lock cells to protect them in Excel - Microsoft Support
On the Home tab, in the Alignment group, select the Alignment Settings arrow to open the Format Cells popup window. On the Protection tab, select the Locked check box, and then select OK …
Tips for Excel for the web - Microsoft Support
Freeze columns and rows to keep them in view while you scroll through your data. Select the cell below the rows, and to the right of the columns you want to freeze.
Freeze fields in an Access datasheet - Microsoft Support
To keep an area of a datasheet visible in Access while you scroll to another area, you can freeze one or more of the fields (columns). The fields that you freeze move to the leftmost position on …
Excel not responding, hangs, freezes or stops working
These steps can help resolve the most common issues when you receive an Excel not responding error, Excel hangs or freezes when you launch it, or open an Excel workbook.