Data Filter in Excel -

• To filter the data in Excel, first select the header of the table. 
• Now go to the Editing tab in the Home Menu, click on the Short & Filter option here 
• Now select Filter in the menu, the Icon of Funnel is made on the Filter. 

•  As soon as you select Filter, a menu will open on the header of your table, Text Filter will be given below, with this Text Filter you can filter your data. 
• 
  

• Now you have to do this, if you want to filter the data from any text, only keep ticking it in the menu, from the rest of the text and remove the tick from Select All.