If you want a drop-down control that filters an Excel table, the most reliable built-in choices are the filter arrows in the table headers or a slicer. Data Validation drop-down lists are for controlling cell input; they do not automatically filter a table.
Steps
Step 1: Turn the data into a table
Click inside the data and choose Insert > Table, or press Ctrl+T. Confirm the range and whether the first row contains headers.
Step 2: Use the header filter
Select the drop-down arrow in the column you want to filter.
Step 3: Choose the values to display
Clear Select All if needed, select the items you want, and choose OK.
Step 4: Add a slicer for a larger clickable filter
With the table selected, use the Table Design tab and choose Insert Slicer when your Excel version provides it. Select the field you want to filter.
Step 5: Clear the filter when finished
Use the column filter menu or the slicer’s clear-filter control to display all records again.
What Happens Next
Excel hides rows that do not meet the selected filter while keeping the underlying records in the table. A slicer provides a visual set of buttons for the same general filtering task.
Troubleshooting and Useful Details
If your actual goal is a drop-down inside a cell, use Data > Data Validation > List instead. That creates an input list, not a table filter, unless you add formulas or other logic that uses the selected value.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.