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.

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.

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.

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

如何在 Excel 中凍結窗格，讓工作表中的列或欄在捲動時仍可見，或鎖定它們以建立多個工作表區域。

วิธีการตรึงแนวใน Excel เพื่อให้แถวหรือคอลัมน์ในเวิร์กชีตของคุณมองเห็นได้ในขณะที่คุณเลื่อนดู …

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. For example, select cell B3 if you want …

Freeze the top row of headings Freeze the top row of column headings so that only the data scrolls. Press Enter or Esc to make sure you're done editing a cell. Select View, Select Freeze Panes, then …

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