I would activate the sheet in question and go to VBE (Alt+F11) and get into Immediate window (Ctrl+G) then copy and paste the following code line into this pane:
Code:
ActiveSheet.Range("A100:A5000").EntireRow.Delete
Then finally hit Enter key to execute the code.
Or following will select the rows you need when executed:
Code:
ActiveSheet.Range("A100:A5000").EntireRow.Select
and now you don't need to select them by scrolling down.