Excell Search field.JPG

Please help me with issue relate to "Search field" in filter, please look print screen in the attached file. I can`t filter particular text in column , now i need to search it manual. If somebody know how to fix this issue please will be appreciate .

The second issue is about deleting range of cell , when I select range of cells and press delete key , only delete first cell not all range that I selected .

Thank you in advance