你有没有在Excel工作表中工作过长或过宽，必须上下左右滚动，让你的胳膊很累？冻结^(Freezing)和拆分^(Splitting)屏幕是一种使页面之间的导航和查看更易于管理的方法。

在 Excel 中冻结和拆分窗格

冻结窗格^{(Freezing Pane)}使行和列保持可见，而工作表的其余部分滚动（基于当前选择）。

• 冻结首行^{(Freeze Top Row)}：在滚动工作表的其余部分时保持首行可见。
• 冻结第一列^{(Freeze First Column)}：滚动工作表时保持第一列可见。

Split将窗口分成不同的窗格，每个窗格分别滚动。

在本文中，我们将解释：

1. 如何冻结单行和单列
2. 如何冻结多行和多列
3. 如何瞬间冻结行和列
4. 如何解冻所有行和列
5. 如何垂直和水平分割窗口
6. 如何删除拆分

1]如何在^(How)Excel中冻结单行和单列

要冻结单个行或列，请单击“视图”^(View)选项卡，单击  “冻结窗格^{(Freeze Panes)}”，然后单击  “冻结首行”^{(Freeze Top Row)}或“冻结第一列^{(Freeze First Column)}” 。在本文中，我们将选择Freeze Top 行^{(Freeze Top row)}。请注意^(Notice)，当您在工作表中滚动时，第一行仍然显示并且没有消失。

2]如何^(How)在Excel中冻结多行和多列^(Excel)

冻结^(Freeze)多行或多列。通过单击行或列的标题来选择要冻结的行或列。转到视图^(View)选项卡，单击冻结窗格^{(Freeze Panes)}，然后单击下拉菜单中的冻结窗格。^{(Freeze Pane)}

阅读^(Read)：如何在 Microsoft Access 中为查询或表创建和修改表单。

3]如何^(How)在Excel中瞬间冻结行和列^(Excel)

瞬间冻结行和列。选择行和列的右侧，然后转到View选择Freeze Panes。单击冻结窗格^{(Freeze Pane)}。请注意，当您向上滚动时，第一行不会消失，而当您向下滚动时，您选择的行左侧的列不会移动。

4]如何^(How)在Excel中解冻行和列^(Excel)

要解冻行和列，请继续查看^(View)并在下拉菜单中选择Freeze Pane并选择^{(Freeze Pane)}Unfreeze Pane。

5]如何^(How)在Excel中垂直和水平分割窗口^(Excel)

在Excel中拆分窗口。单击行或列标题，在Window Group的View选项卡上选择Split。您将在工作表中看到一条粗灰线^{(Thick Grey Line)}；您可以将此线拖动到窗口中要拆分的位置。您将看到工作表的拆分（如上图所示）。

阅读^(Read)：如何在 Microsoft Excel 中为文本添加项目符号^{(How to add bullet points to text in Microsoft Excel)}。

6]如何在Excel中删除拆分

转到视图^(View)选项卡，再次单击拆分^(Split)。工作表中的拆分将被删除。

我希望你觉得这篇文章有用。

How to Freeze and Split Panes in Excel worksheets

Have you had any work in an Excel worksheet that is too long or wide, and you must scroll up and down, side to side, and it makes your arm tired? Freezing and Splitting screens is a method that makes navigation and viewing between pages more manageable.

Freeze and Split Panes in Excel

Freezing Pane keeps rows and columns visible while the rest of the worksheet scrolls (based on current selection).

• Freeze Top Row: Keep the top row visible while scrolling through the rest of the worksheet.
• Freeze First Column: Keep the first column visible while scrolling through the worksheet.

Split divides the window into different panes that each scroll separately.

In this article, we are going to explain:

1. How to freeze a single row and column
2. How to freeze multiple rows and columns
3. How to instantaneously freeze row and column
4. How to unfreeze all rows and column
5. How to split windows vertically and horizontally
6. How to remove Split

1] How to freeze a single row and column in Excel

To freeze a single row or column, click on the View tab, click  Freeze Panes, and then click  Freeze Top Row or Freeze First Column. In this article, we are going to choose the Freeze Top row. Notice that when you are scrolling in the worksheet, the first row is still showing and not disappearing.

2] How to freeze multiple rows and columns in Excel

To Freeze multiple rows or columns.  Select the rows or columns you want to freeze by clicking the heading of the row or column.  Go to the View tab, click Freeze Panes, Then click Freeze Pane in the drop-down menu.

Read: How to Create and Modify a Form for a Query or Table in Microsoft Access.

3] How to instantaneously freeze row and column in Excel

To instantaneously freeze the row and column.  Select the row and the right of the column, then go to View select Freeze Panes. Click Freeze Pane. Notice when you are scrolling up, the first row is not disappearing, and when you are scrolling down, the column on the left of the row you select is not moving.

4] How to unfreeze rows and column in Excel

To unfreeze row and column, go on View and select Freeze Pane in the drop-down menu choose Unfreeze Pane.

5] How to split windows vertically and horizontally in Excel

To split windows in Excel. Click a row or column heading, select Split on the View tab in the Window Group. You will see a Thick Grey Line in the worksheet; you can drag this line to where you want to split in the window. You will see a split of your worksheet (seen in the photo above).

Read: How to add bullet points to text in Microsoft Excel.

6] How to remove Split in Excel

Go to the View tab click Split again. The split in the worksheet will be removed.

I hope you find the post useful.

Related posts

• 如何在Excel中使用Percentile.Exc function

• 如何使用NETWORKDAYS function在Excel

• 如何计算在Excel的Yes or No entries数

• Excel，Word or PowerPoint上次无法启动

• 如何在Excel中使用Automatic Data Type feature

• 运行时error 1004，不能在Excel运行Macro

• 如何在Excel中使用Rept Function

• 如何在Excel中创建Organization Chart

• 如何在Excel中添加Country or Area Code至Phone Number List

• How以使用Excel的Mode function

• 如何计算Excel中的百分比increase or decrease？

• 如何修复损坏的Excel Workbook

• 如何在Microsoft Excel中使用HLOOKUP function

• 如何在Excel formula中锁定单元格以保护它们

• 如何在Excel spreadsheet中插入Dynamic Chart

• 如何将一列拆分为Excel中的多列

• 如何在Microsoft Excel中提取URLs中的域名

• 如何在Excel创建和使用Form Controls

• 如何在Excel中使用DISC function

• 如何启动Word，Excel，PowerPoint，Outlook在Safe Mode