Fix the end Of the header table in Excel

Objective: To fix the header in Excel (no matter how you drag a pull bar, the header is fixed and only the data in the middle is moved)

 

Example:

Name gender age
Li male 28
Wang male 27

Liu Male 28
Sun male 27

Zhang Male 28
Qin male 27

 

Operation Method:
Click in the cell where the first data entry is located (that is, the cell where the "Li" is located), and execute "window" -----> "Freeze pane.

After execution, a straight line extending horizontally to the right is displayed on the bottom line of the header.