Excel 200

When I have a filter such as "NonBlank" - I enter data into the cell
The filter doesn't refresh unless I re-select filter "NonBlank"

Is there a way to make the filter refresh as soon as data is entered
That way the row is no longer visible