-
Open Excellentable in edit mode and go to the "Data" Tab.
-
Select the whole column or a range in which the Filter needs to be applied
-
Click the Filter Button and then the drop down button will be enabled on the first row, for each selected columns.
-
Click on the particular column's arrow button to apply the filter.
-
User can customize the filter by checking the desired values.
-
User can even do partial filtering with the given value in search filed option
