Excel How To Delete Empty Rows. Apply find & select tool to erase infinite rows in excel. Hit the following keys one after the other & not simultaneously.

Now we have a clean list where all of the rows contain a value. In the cells section of the home tab, click delete: The first thing you need to do is to locate and click on the go to special command.