同时冻结第1行和第A列[关闭](Freezing Row 1 and Column A at the same time [closed])

同时冻结第1行和第A列[关闭](Freezing Row 1 and Column A at the same time [closed])

我想在Excel 2010中同时“冻结”第1行和第A列。

这可能吗？

I want to "freeze" Row 1 and Column A simultaneously in Excel 2010.

Is this possible?

最满意答案

选择单元格B2，然后单击“冻结窗格”，这将冻结第1行和第A列。

为了将来参考，在Excel中选择冻结窗格将冻结所选单元格上方的行，并将所选单元格左侧的列冻结。 例如，要冻结行1和2以及列A，您可以选择单元格B3，然后单击冻结窗格。 您还可以通过选择单元格C2并单击“冻结窗格”来冻结列A和B和行1。

Excel 2010中冻结窗格的视觉辅助 - http://www.dummies.com/how-to/content/how-to-freeze-panes-in-an-excel-2010-worksheet.html

Microsoft参考指南（更复杂，但资源不足） - http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP010342542.aspx

Select cell B2 and click "Freeze Panes" this will freeze Row 1 and Column A.

For future reference, selecting Freeze Panes in Excel will freeze the rows above your selected cell and the columns to the left of your selected cell. For example, to freeze rows 1 and 2 and column A, you could select cell B3 and click Freeze Panes. You could also freeze columns A and B and row 1, by selecting cell C2 and clicking "Freeze Panes".

Visual Aid on Freeze Panes in Excel 2010 - http://www.dummies.com/how-to/content/how-to-freeze-panes-in-an-excel-2010-worksheet.html

Microsoft Reference Guide (More Complicated, but resourceful none the less) - http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP010342542.aspx