Data Validation and Column filtering

Take this:

1. Remove Filters Temporarily:
   • Go to the Data tab.
   • Click on Clear in the Sort & Filter group to remove all filters temporarily.
2. Add Data Validation:
   • Select the cells in the column where you want to add the drop-down list.
   • Go to the Data tab.
   • Click on Data Validation in the Data Tools group.
   • In the Settings tab, choose List from the Allow drop-down menu.
   • Enter the list of items you want in the Source box.
   • Click OK.
3. Reapply Filters:
   • Select the entire range of your data.
   • Go to the Data tab.
   • Click on Filter in the Sort & Filter group to reapply the filters.