EXCEL TRICK - Select large data quickly in columns & rows WITHOUT click & drag or unwanted cells

A really fast way to select huge runs of data in columns or rows quickly without picking up unwanted cells. Way faster than click-n-drag selecting and more targeted than selecting the whole spreadsheet's column or row.
***UPDATE - Additional Info*** If your data range selection with this trick does hit a blank cell and stops, you can just tap the direction arrow a couple times to get past it, then take your fingers off the keys and hit the three button combo again to resume selection to the bottom of the data or the next blank cell.

[ricklemanczyk]

Thanks Pete...saved me buckets of time, not to say sore fingers!

[eddieeriksson]

Saved me a lot of frustration! Thank you!

[AnomalyBelleza]

This helped me today. Thank you very much for videos like this.

[ATPhilippines]

Thanks for this, this helped me in my work!

[navdeepdhillon]

Thank you so much… I had a large large file it had 612k txns 😢 So I used that idea of leaving one row blank and was able to copy the data in three segments 200k each and created three separate files 😊 Tysm

[gazimahfuj]

Thanks, It will save a lot of time and frustration.

[NorthFloridaLiving]

Nice. Just what I was looking for. Good presentation.

[louiefelecio]

Thank you so much, it's a big help to me.

[turki]

Thank you, and God bless you
That really was helpful ❤

[Tiago.Bernardino]

Hey thank you very much for this trick, I do need help with the same thing but different way.
Since I have calculated data in one master sheet taking results from 2 sheets how do I implement this, because when I do it since there's no data on that master since it's going to be populated when I drag with the results from the two sheets and it stops at 100k+ rows and I need it to stop where the other two sheets data end which I have no clue how to do it?

[Tjousk]

If you come to a gap in your data, keep holding shift, let go of end, arrow key past the gap, then end+arrow again.
The only key you have to hold is shift. You can press and release end then press an arrow.
There's also shift+ctrl+end to select all rows and columns from the current cell to the end of the data.

[gregjerry]

Thats one headache permanently cured 👍

[joshuaknight]

My Shift+end+down highlights all columns with data, not just the one I ighlighted.