There is no problem not worth solving, and no technology not worth learning!

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

仅能够截止至日期为 4.30 的那一行,之后的行无法筛选成功

作者:

,

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

在一个 Excel 中筛选时,筛选:揭美娜
Figure 1

 

仅能够截止至日期为 4.30 的那一行,之后的行无法筛选成功
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

发现 日期为 5.1 那一行,每一列都存在筛选按钮,感觉像是新开启了一个表格
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

最终决定剪切从 日期为 5.1 的那一行开始的所有行,排除掉序号列
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

发现 日期为 5.1 那一行,筛选按钮已经消失,筛选:揭美娜,筛选成功,符合预期
Figure 7

Need long-term technical maintenance or remote troubleshooting?

I am a PHP / Go backend engineer with 15+ years of experience, focused on existing system maintenance, bug fixing, performance optimization, server troubleshooting, WordPress maintenance, and small feature iterations.

If your project is facing any of the following issues, we can start with a small troubleshooting task first:

  • ✅ PHP / Laravel / Yii2 legacy systems without active maintenance
  • ✅ Go / Gin backend APIs that need troubleshooting or optimization
  • ✅ Slow, broken, or unstable WordPress websites
  • ✅ Nginx / MySQL / Redis / Linux server issues
  • ✅ CDN / Cloudflare / DNS / HTTPS configuration problems
  • ✅ Long-term remote technical support or part-time maintenance

More details: About Me & Collaboration

WeChat: 13980074657
Email: shuijingwanwq@gmail.com
Telegram: @shuijingwan
GitHub: https://github.com/shuijingwan

评论

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.