Current location - Recipe Complete Network - Complete cookbook - How to freeze panes with multiple rows and columns in Excel?
How to freeze panes with multiple rows and columns in Excel?
The operation method is as follows:

1. First find the view, freeze the pane and freeze the first line, as shown in the following figure:

2. Click the "Split" option again, as shown in the following figure:

3. If the first four lines need to be frozen, put this line below the fourth line, as shown in the following figure:

4. Select the Freeze Split Pane option again, as shown in the following figure:

5. Finally, fix the corresponding multiple lines respectively, as shown in the following figure: