Use this gainful tool to delete only visible rows in a selection. It does not delete hidden rows. Consider the following example:
Select Delete > Rows > Visible. The database will look as follows: