Deleting Visible Cells

Alright guys,

I have a data in which I have inserted a table with headers.

I then filter the type of data I want removed from the table using the drop down

Then goto special, visible cells only, press delete.

Now, the data is gone, but when I select all again to pull up the entire table, the data is gone, but rows are still there. So now I have tons of empty rows in between the rows of needed data.


Any way of removing the rows in between as well as the data?
Any help will be appreciated.

An alternative would be, presss 'CTRL Key' & '- Key' at the same time after filtering the data. A confirmation window will pop up. Press "Yes"

All the delete options are greyed out, except for delete sheet, which removes everything?

Is it 'Delete Sheet' or 'Delete Entire Sheet Row'? If you are getting the latter option, then press "Yes".