The best way to freeze the first row and the first column in Excel

Step one: In Excel, click to select the B2 pane, perform the window → split command (Figure 1), and then the effect shown in Figure 2 shows that the window split was unsuccessful if the effect shown in Figure 2 does not appear.

Step Two: Click to select the A1 cell in the upper-left corner and perform the window → Freeze panes command (Figure 3).

This is the perfect time to freeze the first row, the first column effect (Figure 4). For some more data tables, the need for a fixed header or the first column, frozen after the view is much more convenient. Have you met the Xiuxiu teacher's problem yet? Don't hurry to learn the trick.