Excel: Quickly Select a Large Amount Amount of Data/Cells

This video demonstrates how to quickly select large amounts of data in Excel. In the example we select 20,000 rows of data within a 40,000 row dataset.
------------------------

[@josephrobertsirgo4019]

I cant remember the time I appreciated the content of an informational tutorial but yours, on this topic is right to the point clear and concise and most importantly it works. thank you.

[@user-mz9sx1wk9k]

THANK YOU! *FINALLY* got the answer to this question. I need to select 20,000 cells in groups, because my SQL select in another window is too big. FINALLY I can select 20,000 groups of numbers in Excel so I can paste that into my SQL select window!

[@deshkumar9]

Thank you so much for this useful tip as it saved me lot of time. I just did one modification, I selected the cell of the last column till where I wanted to select the data and then press shift + enter. Have subscribed your channel for more.

[@vipulagora1325]

Awesome man, you are the best. You saved my time.

[@laurad.cutler4806]

So helpful! Thank you!! I needed to sort about 29,000 pieces of data. Thanks to your video, I did it in a flash:)

[@ryancwiese]

😊

[@OneNeverEnds]

Clear and to the point - thank you!

[@ibnumohamed9658]

Thank you so much for this.

[@excursioncouple]

i just did this formula on the name box (A1:m20000) and it selected the range

[@bradcasper4823]

It doesn't work for me. It moves me to entered field.

[@kaokaorium8741]

Try formula format A1:D10000 on the name box, this worked for me 0:47

[@utkarshkulkarni7573]

Thank you so much for making our life easy

[@date_with_life1820]

thanks a lot for making this video

[@Langeloudspeakers]

Thank you for sharing!

[@TheSupremeShaman]

Brilliant! Almost 75000 rows was quite a bit to manage.

[@sichonechanda5259]

Many thanks, worked for me. Now I can teach my supervisor something hehehehehe......

[@asadullah1075]

Thank you sooo much saved a lot time.

[@Mark-OutWest]

Thank you life saver! I have a spreadsheet with 950,000 lines that can't be emailed.

[@tinselyaa3061]

Thank you for the video

[@zigadomel]

Thank you so much you just save my day

[@sarapalestini741]

Thank you so much you just saved me so much time!

[@hendrag593]

Thank you very much for this great video.. GBU..

[@R_Bizzness]

thank you - it is what I was looking for

[@JohnSarz]

Awesome! Thanks a million, buddy! 🙇‍♂

[@ChesterTugwell]

No problem 👍

[@gibingeorge7421]

Life saver Thank you very much

[@deddyandy7306]

Wow thanks a lot. I need to move around 49 columns where each column consists of 3720 rows

[@pavelroll4318]

LEGEND! thank you

[@kimmedina8076]

Thank you!!

[@StevenPhan-ib6ew]

thank you

[@carlos_mann]

Is there a way i can do that, but using the text fields from an mp3. I want to print out a song list without having to type out all the metadata (artist, title, length, etc). Is there an easy way to do something like that with excel?

[@appocalypse3012]

thank u