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

thank you!

Thanksssssss a lotttttttttttttttt This what worked with me. the video instruction did not work ! Thanks for posting it

Thank you 🌸🌹❤️

You saved me!!!!

If there is a blank cell selection stops there

you are amazing bro thanks

Thanks for the extra tips. I noticed also you can release the keys, leave your selection highlighted, and then hit shift+end+(different arrow key) and continue the block selection in a different direction.

This worked for me too!

thank you!

Neither did I at first. Try looking on the top row, far right of your screen. On my laptop it’s the very last key!

Hold down Ctrl and left-click the top of each column, although this will select the entire column, not just the data in the column.

If you put a blank row between the sections you need to split of your larger spreadsheet and then use the select trick in this video you can batch select the data between the blank rows.

Lots of of missing cells might make it faster to just select the whole column rom the top (click the column cell (A, B, etc.), but if you've just got some random missing cells here and there 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.

shift+control+arrow you need

Just off the top of my head I would insert a blank row between 99 and 100 and then another between 1000 and 1001 and then do the select trick. (After you copied the data you want you could just go back and delete the blank lines.) There's probably a better way, but that's just what popped into my head as this select feature halts on a blank. You probably don't even need a blank row between 99 and 100, just highlight row 100 and then hit Ctrl - END - Down arrow and it should drop right to line 1000 (assuming you have a blank line at 1001.)

Select the first row you want by left clicking the row number, scroll down as many rows as you need, hold Shift and left click the last row number you want. This should select all the rows between your first and last selection.

@@WheeliePete hello, thanks..but if i want to skip manually selecting..cause the number of rows to be selected might not always be counted..for example as from row 37 i need to select only 23 more rows..is there any shortcut to designate the specific number of rows we are to choose?

I haven't had a problem with extremely large spreadsheets in quite a while. In earlier versions I think Excel only supported up to 65,536 rows, but now with newer versions it'll support 1,048,576 rows x 16,384 columns. I haven't had a problem with large spread sheets crashing my systems though. I wonder if you've got an available memory issue with not enough RAM? Usually the system will tell you if you're running up against a memory limit though...

yes

That selects to the bottom of the spread sheet, not the bottom of the data run.

If your data range selection hits 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. I don't know a way to force selection from top to bottom that would contain blank cells in between. Maybe someone else will chime in if there's a way to do that.

@@WheeliePete yeah... Thank you so much for the reply... Btw I got the answer... Let's say column C contains the data along with blank cells where C1 is the column heading. So, in the Name Box type C2:C20000 (i.e; any arbitrary number for 2nd value) then press the ctrl+shift+up arrow In this way, we will have the column selected with blank cells too