How to filter data in Excel across a whole sheet 2. Click on "Data" in the top toolbar. 3. Click on "Filter" in the top toolbar. This will show an arrow at the top of every column. 4. Click on the ...