同时冻结第1行和第A列

问题描述

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

这是可能吗？

解决方案

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

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

Excel 2010中冻结窗格的视觉辅助 -

Microsoft参考指南（更复杂，但资源不足） -

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

Is this possible?

解决方案

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

这篇关于同时冻结第1行和第A列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！