1. Open Excellentable in edit mode and go to the "Data" Tab.



  2. Select the whole column or a range in which the Filter needs to be applied



  3. Click the Filter Button and then the drop down button will be enabled on the first row, for each selected columns.

     


  4. Click on the particular column's arrow button to apply the filter.




  5. User can customize the filter by checking the desired values.

     




  6. User can even do partial filtering with the given value in search filed option