How does Excel freeze a table window?

How does Excel freeze a table window?

1, first of all, open a form, random input some items, as follows:

2, in the Excel Options page, select the "View" item, as follows:

3. In the View Options page, there are "window" sub-items, as follows:

4. In the Window section, select Frozen form, as follows:

5, pop-up dialog box is as follows:

6, the title, choose "Frozen First line", no matter how much data entered the first row is displayed in the top row, as shown:

7, the frozen position below will appear a black line, proof has been frozen, the following figure: