表头冻结列冻结_如何在Excel中冻结和取消冻结行和列

表头冻结列冻结

If you are working on a large spreadsheet, it can be useful to “freeze” certain rows or columns so that they stay on screen while you scroll through the rest of the sheet.

如果您使用的是大型电子表格，则“冻结”某些行或列以使它们在滚动表的其余部分时保留在屏幕上会很有用。

As you’re scrolling through large sheets in Excel, you might want to keep some rows or columns—like headers, for example—in view. Excel lets you freeze things in one of three ways:

当您在Excel中滚动浏览大型工作表时，您可能希望在视图中保留一些行或列(例如标题)。 Excel使您可以通过以下三种方式之一冻结内容：

• You can freeze the top row.
  您可以冻结第一行。
• You can freeze the leftmost column.
  您可以冻结最左边的列。
• You can freeze a pane that contains multiple rows or multiple columns—or even freeze a group of columns and a group of rows at the same time.
  您可以冻结包含多行或多列的窗格，甚至可以同时冻结一组列和一组行。

So, let’s take a look at how to perform these actions.

因此，让我们看一下如何执行这些操作。

冻结第一行 (Freeze the Top Row)

Here’s the first spreadsheet we’ll be messing with. It’s the Inventory List template that comes with Excel, in case you want to play along.

这是我们将要使用的第一个电子表格。 如果您想一起玩的话，这是Excel随附的库存清单模板。

The top row in our example sheet is a header that might be nice to keep in view as you scroll down. Switch to the “View” tab, click the “Freeze Panes