Share via

Delete infinite rows from Excel

Anonymous
2020-02-08T21:47:33+00:00

I have tried F5, special, GO TO, Blanks, right click, delete - nothing happened.

Too many to highlight by hand and delete.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. OssieMac 48,001 Reputation points Volunteer Moderator
    2020-02-08T22:59:18+00:00
    1. Select the entire range and apply AutoFilter.
    2. Click an AutoFilter DropDown
    3. Uncheck all and then check the blanks option only (So only blanks visible)
    4. If it is entire rows of blanks that you want to delete and some columns have data in them then repeat 2 and 3 for all columns of data.
    5. Excluding the column headers, select entire rows for all visible area of the AutoFilter range. (Row identifiers down left of page should be blue for the filtered range so you can see jhow far down to select)
    6. Select "Find & Select" (Far right of Home ribbon)
    7. Select "Go to Special"
    8. In the dialog Select "Visible Cells only" and OK
    9. Right click over the selection and select "Delete rows"
    10. Remove AutoFilter and you should be left with the non blank rows only

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more