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.

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 …

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

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.

Freeze columns and rows at the same time 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 …

如何在 Excel 中冻结窗格，使工作表中的行或列在滚动时可见，或将它们锁定到位以创建多个工作表区域。

You can also split on both a row and a column. by selecting the cell below and to the right of where you want the split—then click Split. In the figure below—because D5 was chosen—columns to its left (A …

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.

If you scroll down your worksheet but always see the same top rows, they're locked in place (frozen). Use the Unfreeze Panes command to unlock those rows.

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.