Filter Excel Data Instantly with Slicers (Zero Formulas) Filtering in Excel doesn’t need to involve complex menus or formulas. If you want a clean, visual, one-click filtering experience, Slicers are the perfect solution. Below is a simple and effective way to set it up. Step 1: Turn Your Data into a Table Slicers work only with Excel Tables or PivotTables, so this step is mandatory. • Click anywhere inside your dataset • Press Ctrl T • In the dialog box, confirm My Table Has Headers • Click OK