Observe: When you use the Discover dialog box to look filtered data, only the data which is displayed is searched; information that is not displayed is just not searched. To look all the data, distinct all filters. Important Takeaways Auto Filter in Excel helps you to Show rows immediately a