Tip: If you need to apply a predefined or custom made filter for your details, see Filter information in a range or desk Essential Takeaways Auto Filter in Excel lets you Show rows after adding filters on the table. We could add filters to 1 or all columns or simply person cells.  Pi