When filtering in one Excel, only one row can be cut off (the filter button exists in each column of this line)

1. When filtering in an Excel, filter: Jie Meina, only the line with the end of the date is 4.30, and the subsequent row cannot be filtered successfully. Figure 1, Figure 2

Figure 1

Figure 2

2. Discovery The date is 5.1, and each column has a filter button, which feels like a new table has been opened. as shown in Figure 3

Figure 3

3. Open a new row in the first table, and the serial number is continued. as shown in Figure 4

Figure 4

4. The final decision to cut all the rows starting from the line with the date 5.1, exclude the serial number column, as shown in Figure 5

Figure 5

5. Then paste from the date column of the new line. as shown in Figure 6

Figure 6

6. Discovery The date is 5.1, the screening button has disappeared, screening: Jie Meina, the screening is successful, in line with expectations. as shown in Figure 7

Figure 7