How can I quickly delete data hidden a few thousands row below my worksheet

[Stevekent]

I have some data accidentally inserted my worksheet below, say a few thousands row below, how can I select this data and delete it

 

[Michael M]

Goto the last row of the data you want to keep.
Then select the row header of the next row and press CTL + SHIFT + Down Arrow
Now r click and press delete

 

[Alex Blakenburg]

Leveraging off Michael's comment, I would do it slightly differently:
(maybe take a back up of your file first )

1. Go the first blank row below the data you want to keep.
   (ctrl+down arrow on a column that always has data in it will get you close)
2. Ctrl+Shift+End (this will select from there to the end)
3. Ctrl+- (minus sign)
4. In the pop up box - Select entire row

Alternative for 3 & 4

3. Shift+SpaceBar (this will select the entire row)​

4. Ctrl+- (minus sign) will delete the entire selected rows.​

 

[Peter_SSs]

How can we determine what is accidentally inserted and what is not?