Excel 简明教程
Freeze Panes in Excel 2010
Freezing Panes
如果你设置了带行或列标题的工作表，则在向下或向右滚动时这些标题将不可见。MS Excel 通过固定窗格为此问题提供了便捷的解决方案。在滚动工作表时，固定窗格使标题保持可见。
If you set up a worksheet with row or column headings, these headings will not be visible when you scroll down or to the right. MS Excel provides a handy solution to this problem with freezing panes. Freezing panes keeps the headings visible while you’re scrolling through the worksheet.
Using Freeze Panes
按照下面提到的步骤进行固定窗格。
Follow the steps mentioned below to freeze panes.
-
Select the First row or First Column or the row Below, which you want to freeze, or Column right to area, which you want to freeze.
-
Choose View Tab » Freeze Panes.
-
Select the suitable option − Freeze Panes − To freeze area of cells. Freeze Top Row − To freeze first row of worksheet. Freeze First Column − To freeze first Column of worksheet.
-
If you have selected Freeze top row you can see the first row appears at the top, after scrolling also. See the below screen-shot.
