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:
Select area > type any > then ctrl + enter for all area filup.