Excel Filter Function

I have a spreadsheet with lots of data in which the filter will not function correctly. It either does not show the values in all cells or will not filter the value selected.  I have rebooted and tri...