Excel Tricks October 10, 2025 by Dhruba Mondal Table of Contents Toggle 1. Excel trick 2 Automatically insert serial number after filter in Excel2. Auto adjust serial number sequence in excel 1. Excel trick 2 Automatically insert serial number after filter in Excel =SUBTOTAL(103,B$20:B20) Without filter: After filter: 2. Auto adjust serial number sequence in excel =ROW(B36)-34 After delete the Row: