How to freeze excel

Freeze window:

First determine where you want to freeze the pane, and then place the mouse Click once on the cell where this position is located to locate the position to be frozen.

Click the "View" menu tab, click the "Freeze Panes" button in the toolbar, and select "Freeze Split Window" in the pop-up drop-down menu "Grid" command.

Related recommendations: "excel basic tutorial"

In this way, Excel will start from the selected cell in the worksheet Add a horizontal and a vertical split line and freeze the area of ​​the worksheet above the horizontal split line and to the left of the vertical split line.

When we drag the horizontal scroll bar or vertical scroll bar to browse the data, the frozen area will not change, which is more convenient for us to observe the data.

Of course, if you only need to freeze the first row or column, you must select the "View" menu tab and click "Freeze Panes" in the toolbar. button, and select the "Freeze First Row" or "Freeze First Column" command in the pop-up drop-down menu.

Unfreeze:

If you want to unfreeze, just select the "View" menu tab and then click on the toolbar Click the "Freeze Panes" button and select "Unfreeze Panes" from the pop-up drop-down menu.

The above is the detailed content of How to freeze excel. For more information, please follow other related articles on the PHP Chinese website!