How to lock rows in excel:
1. Select the cell in the next row of the row that needs to be fixed, as shown in the figure
2. Find the Freeze Panes button under the "View" menu.
#3. Open the option to freeze windows in the drop-down menu.
4. The menu is divided into three situations: "Freeze Split Pane", "Freeze First Row", "Freeze First Column". As the name suggests, use To freeze rows and columns, only rows, and only columns.
5. The rendering is as shown in the picture:
Recommended tutorial: "excel tutorial》
The above is the detailed content of How to lock rows in excel?. For more information, please follow other related articles on the PHP Chinese website!