excel锁定第一行_将Excel标题行锁定在适当的位置

excel锁定第一行

If you want to scroll down the worksheet, and lock the heading rows in place, so they're always visible, you can use the Freeze Panes command. Be careful though, or you might end up with hidden rows that you can't get to.

如果要向下滚动工作表，并将标题行锁定在适当的位置，以便始终可见，可以使用“冻结窗格”命令。 不过要小心，否则可能会遇到无法访问的隐藏行。

冻结窗格设置 (Freeze Panes Settings)

In Excel 2007 and later versions, there is a Freeze Panes command on the Ribbon's View tab. You can select one of the following commands, to freeze the rows and/or columns in place.

在Excel 2007和更高版本中，功能区的“视图”选项卡上有一个“冻结窗格”命令。 您可以选择以下命令之一，以冻结行和/或列。

• Freeze Panes
  冻结窗格
• Freeze Top Row
  冻结顶行
• Freeze First Column
  冻结第一列

For Excel 2003 instructions, visit the Contextures website: FAQ: How do I lock the Title Row?

有关Excel 2003的说明，请访问Contextures网站： 常见问题解答：如何锁定标题行？

冻结顶行 (Freeze Top Row)

If you select the Freeze Top Row command, the top visible row in the Excel window is frozen. You will not be able to scroll up to see any rows above the frozen row.

如果选择“冻结顶部行”命令，则Excel窗口中的