Locate Line break items and delete

[datadummy]

I am trying to locate all line breaks and delete them in a quicker way then scrolling to locate them all. Please see the attached image to see the highlighted row to understand what the line breaks I'm looking for look like.

 

[Micron]

One example does not provide enough to provide a solution, especially if you don't provide a clue as to the desired result - or at least that's my thought train. What makes a "line break" (what you show is not a line break)? Is it the word "Total" in column E? Is it a blank cell in column A? Something else? Regardless, what should be the result? That row should be deleted? Then what, shift cells up? Leave the row blank?

 

[Peter_SSs]

It looks like your data might have had Excel's Subtotal feature (on the data ribbon tab) applied to it. If that is the case could you just select a cell in that data and use Data ribbon tab -> Subtotal -> Remove All?