Settings for the "EXCEL" Freeze window

When using Excel, when the table content is very large, for the convenience of viewing, you need to freeze some of the content, the frozen window is divided into the following cases, respectively, to parse.

Tools/Materials

• Excel

Freeze first Line

1. 1

   Open the desired table, click "View"----freeze the panes, click "Freeze Panes" and select "Freeze Top Row".

   END

Freeze first Column

1. 1

   And freezing the first row is basically the same operation. Open the desired table, click "View"----freeze the panes, click "Freeze Panes" and select "Freeze first column".

   END

Freeze partial rows, partial columns

1. Sometimes only the first row and the first column are frozen, it is not enough to meet the needs, need to freeze the ranks of the section.

2. For example, if you want to freeze the contents of the first 5 rows and the first 5 columns, select the yellow lattice a (intersection of row Fifth and fifth) in the lower-right corner of B (the intersection of the sixth row and the sixth column).

3. 3

   Click "View"----freeze panes, click "Freeze Panes" and select "Freeze splitter panes" to freeze.

   END

Cancel Freeze window

1. 1

   Click "View"----freeze panes, click "Freeze Panes" and select "Unfreeze panes" to unfreeze. This method is used to unfreeze the panes.

Settings for the "EXCEL" Freeze window