A REVIEW OF AUTO FILTER

Whenever you apply a filter to some column, the only filters readily available for other columns will be the values noticeable inside the at present filtered assortment.AutoFilter in Excel lets us to see precise rows whilst hiding the opposite rows. When Excel AutoFilter is added on the row's header, it presents us a drop-down menu from the header