How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.

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 option you need.

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.

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 column …

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 > …

Cara membekukan panel di Excel agar baris atau kolom di lembar kerja tetap terlihat saat Anda menggulir, atau menguncinya di tempat untuk membuat beberapa area lembar kerja.

When you split a sheet into separate panes, you can scroll in both panes independently. Select below the row where you want the split, or the column to the right of where you want the split.

Print column headings on each page of your worksheet so your readers won’t have to go back to the first page to see the headers.

Kunci baris atau kolom tertentu di tempat dengan membekukan panel, sehingga Anda bisa menelusuri lembar bentang Excel dan masih melihat baris atas atau kolom kiri.

Select View, Select Freeze Panes, then select Freeze Top Row. For more information, such as freezing selected rows and columns in your workbook, see Freeze panes.