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. ------------------------
Пікірлер: 32
@josephrobertsirgo401911 ай бұрын
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-mz9sx1wk9k2 ай бұрын
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.
@vipulagora13252 жыл бұрын
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 Жыл бұрын
😊
@OneNeverEnds2 жыл бұрын
Clear and to the point - thank you!
@ibnumohamed965828 күн бұрын
Thank you so much for this.
@excursioncouple4 ай бұрын
i just did this formula on the name box (A1:m20000) and it selected the range
@bradcasper48232 жыл бұрын
It doesn't work for me. It moves me to entered field.
@kaokaorium87412 ай бұрын
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_life18202 жыл бұрын
thanks a lot for making this video
@Langeloudspeakers2 жыл бұрын
Thank you for sharing!
@TheSupremeShaman9 ай бұрын
Brilliant! Almost 75000 rows was quite a bit to manage.
@sichonechanda52592 жыл бұрын
Many thanks, worked for me. Now I can teach my supervisor something hehehehehe......
@asadullah10756 ай бұрын
Thank you sooo much saved a lot time.
@Mark-OutWest11 ай бұрын
Thank you life saver! I have a spreadsheet with 950,000 lines that can't be emailed.
@tinselyaa30613 жыл бұрын
Thank you for the video
@zigadomel Жыл бұрын
Thank you so much you just save my day
@sarapalestini7412 жыл бұрын
Thank you so much you just saved me so much time!
@hendrag5933 ай бұрын
Thank you very much for this great video.. GBU..
@R_Bizzness Жыл бұрын
thank you - it is what I was looking for
@JohnSarz5 ай бұрын
Awesome! Thanks a million, buddy! 🙇♂
@ChesterTugwell5 ай бұрын
No problem 👍
@gibingeorge74212 жыл бұрын
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
@pavelroll43182 жыл бұрын
LEGEND! thank you
@kimmedina80762 жыл бұрын
Thank you!!
@StevenPhan-ib6ew Жыл бұрын
thank you
@carlos_mann9 ай бұрын
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?