If you need to delete visible blank cells with accuracy,
the way is to select fist row and filter out all blank cells and when you are
going to delete please press F5 and select go to special then select “visible
cells only” and select OK, Go back home and delete directly, all of them will
be removed.