Excel, what effect does the freeze window operation on the worksheet achieve?

excel2007 freeze window - horizontal freeze a line method:

If you want to freeze a row, you first need to select the row below it. The simple thing would be this: if I need to freeze the "a2" line now, then I must select the "a3" line;

Then go to the "View" tab, click "Freeze Pane" in the "Window" option group, and select "Freeze Split Pane" in the following menu!

After setting the freeze window, we can see that there is an extra horizontal line on the "A2" line!

excel2007 freeze window - vertical freeze a line method:

The method of vertical freezing in excel is the same, and I skipped this one.

excel2007 freeze window - freeze horizontally and vertically (a row and a column) at the same time:

I don't know if you have noticed that in the above method, we can't fix "a certain row and a certain column" at the same time, either freeze a certain row or freeze a certain column. Here's how to fix "a row and a column" at the same time.

I want to freeze "Row A2" and "Column A1" now, what should I do?

Click the mouse to select the "B3" cell, and then click View-->Freeze Pane-->Freeze Split Pane.

After setting the freeze window, two black lines will appear, which proves that it is OK!

To put it simply, horizontal freezing means freezing rows, vertical freezing means freezing columns, and horizontal and vertical freezing means freezing rows and columns at the same time.

When using Excel2007, the view - freeze pane (which is divided into freeze split spaces, freeze the first row, freeze the first column, that is, correspond to the horizontal and vertical freeze, horizontal freeze, vertical freeze) as shown below

If you want to freeze a row, select and hold the next row of the row and click Freeze Split Pane, and if you want to freeze a column, select and hold the next column of the column and click Freeze Split Pane.

If you want to freeze a row + a column, select and hold the cell in the upper left corner outside the intersection area between the row and the column, and click "Freeze Split Pane".

What is the Freeze Pane feature in Excel? How does it work?

In Excel, when you view a large worksheet, if you only view one section, then you want that section to be visible all the time so that you can scroll freely in that section and the other areas will remain the same, which is what the Freeze Rent Friends pane feature is for. To the disadvantages of the following are the steps to use the freeze pane cavity good features:1

Select the cells below and to the right of the rows and columns you want to freeze. 2.Click the Freeze Pane button in the View tab.

3.If you only want to freeze a column or row, you can select the cells in the column or row, and then click the Freeze Pane button in the View tab and select Freeze Selected Columns or Freeze Selected Rows. This will enable you to scroll through other rows and columns in the worksheet while keeping the other cells unchanged.

If you don't need the feature, you can click the Unfreeze Pane button in the View tab again to disable the feature.

1. The excel freeze window is divided into three situations, freeze the first row, freeze the first column, and freeze the split pane.

2. Freeze the first line. If you only want to freeze the first row, click any cell in the excel sheet and select View-Window-Freeze First Row. This way, the first row remains visible as you scroll up and down the data.

3. Freeze the first column. If you only want to freeze the first column, click any cell in the excel sheet and select View-Window-Freeze First Column. This way, column A stays still as you scroll the data left and right.

4. Freeze the split pane. Click to select the cell that you want to freeze the bottom row of the row and the column to the right of the column you want to freeze, that is, cell B2, and click View-Window-Freeze Split Pane. This completes the excel freeze window.

The way to freeze the window in excel is:

1. First open**, open excel**;

2. After opening, you can see the toolbar of the table, and then select the view in the toolbar;

3. Click on the view, there is a freeze window below, choose to freeze the first row, if you want to freeze the column, you can also see if you want to freeze the row or the column;

4. Click on the freeze, we go back to the page, and then swipe up and down to see that the first line is not moved when sliding;

5. If you want to cancel it after freezing, it's very simple, or in the freeze window of the view, click to cancel the freeze.

How to set Excel2007 Freeze Window.

1. Freeze the first line

1. Open the Excel2007 worksheet you want to freeze, and click "View" to switch to the tool panel.

2. Click Freeze First Line under Freeze Pane.

3. At this time, you can see that the first row is fixed, as shown in the red box in the figure below, and the data below can be viewed by sliding the mouse or dragging the scroll bar.

2. Freeze the first column

Excel2007 freezes the first column in a similar way to freeze the first row.

1. Open the Excel2007 worksheet you want to freeze, click "View" to switch to the tool panel, and then click "Freeze Header" under "Freeze Pane".

2. At this time, you can see that the first column is fixed, as shown in the red box in the figure below, and the one on the right'The data is viewed by sliding the mouse or dragging the scroll bar.

3. Freeze any position

We can also customize which cell areas of the Excel2007 freeze window.

1. Click the freeze position you want to set, and select the lower right corner of the cell as the viewing area, which can be moved freely, and the other positions are fixed areas. Next, click Freeze Split Pane under Freeze Pane, and in this example, freeze row 1 and column A.

2. After completion, the first row and column A are finally displayed, so that you can check the hidden results of any student in any subject.

We all know the convenience of excel software, it has a special function is to freeze the window, it is designed for the convenience of viewing report data, easy to browse the data, especially when the statistics are made, the "freeze window" function is particularly important, how to freeze the excel window, below, the socks to show everyone the operation process of freezing the excel** window.

When viewing a relatively large worksheet in excel, it is difficult to compare the data of different parts of the table, at this time we can use the freeze window function in the worksheet to fix the window, but even if many users are using excel, there are not many users who know how to freeze the window.

How to freeze the Excel window.

Let's take freezing the window of the third row as an example.

Excel Diagram-1

Click the mouse to select the fourth row, and click "View" "Freeze Pane" "Freeze Split Pane" in the menu bar.

Freeze Window Diagram-2

In this way, the mouse scrolls down, and the cells above the thick black line are fixed. To put it simply, it's just to click on the next row of the cells you need to freeze.

Freeze Window Fig-3

If you want to cancel this setting, click "View" in the menu bar, then "Freeze Pane" and "Unfreeze Pane", so that the setting just now is canceled.

**Figure 4: If you want to freeze certain rows and columns of the window, how can these rows and columns be fixed when the mouse scrolls down?

Let's take the window that freezes column c in row 9 as an example. Click the mouse to select cell D10, and click "View" "Freeze Pane" "Freeze Split Pane" in the menu bar. That is, click on the intersection of the next row and column cells of the next row of cells you need to freeze.

Freeze Window Diagram-5

When the window is frozen, the mouse scrolls down and the cells above the line pointed by the arrow are fixed.

Freeze Window Figure-6

Again, drag the scroll bar to the right and down to see that the position of the frame line is fixed.

excel drawing-7

If we want to cancel these settings, click on "View" in the Celery menu bar again, then "Freeze Pane" and "Unfreeze Pane", and then cancel the settings just now.

excel-8

The above is the operation method of freezing the excel** window, I believe it will be helpful to you after reading it.