When you use a filter to some column, the sole filters accessible for other columns would be the values noticeable while in the now filtered array. AutoFilter in Excel will allow us to see distinct rows though hiding the other rows. When Excel AutoFilter is additional on the row's header, https://franciscoxwutt.thelateblog.com/34210884/considerations-to-know-about-auto-filter