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

Рет қаралды 263,187

3 жыл бұрын

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.

Пікірлер: 112

@MaheshKumar-en5yh 2 жыл бұрын

Ur concise info is worth to watch.

@eddieeriksson5830 3 ай бұрын

Saved me a lot of frustration! Thank you!

@AnomalyBelleza 4 ай бұрын

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

@venkatprabhu2057 2 жыл бұрын

exactly what i searched for thank you

@ricklemanczyk2966 2 жыл бұрын

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

@ATPhilippines Жыл бұрын

Thanks for this , this helped me in my work!

@navdeepdhillon4764 2 ай бұрын

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

@gazimahfuj9147 22 күн бұрын

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

@DirtyDanGamingYT Жыл бұрын

Thank you this is what I needed!

@KhairiDarweesh Жыл бұрын

That's very helpful, thank you!

@telaadvisor Жыл бұрын

You just save my day; thank you.

@fluidlevels 11 ай бұрын

THANK YOU!

@turki3289 9 ай бұрын

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

@alexrivera7598 2 жыл бұрын

I use ctr shift arrow

@celseac8107 2 жыл бұрын

This worked for me too!

@prayashpanda7884 2 жыл бұрын

thank you!

@louiefelecio746 Ай бұрын

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

@loagahoo1 2 жыл бұрын

shift + Ctrl and down arrow works.

@code.badger 2 жыл бұрын

thank you!

@josspeace9841 2 жыл бұрын

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

@Moondisapear 2 жыл бұрын

Thank you 🌸🌹❤️

@pearlmeyy1786 Жыл бұрын

You saved me!!!!

@vamanshenoy938 3 ай бұрын

If there is a blank cell selection stops there

@LyLeinUS 9 ай бұрын

thank you, that helps a lot!

@glovespaulo1342 2 жыл бұрын

Thank you this short video helped

@bongiperez7565 10 ай бұрын

Most succint video. Thank You!

@gregjerry4110 Ай бұрын

Thats one headache permanently cured 👍

@marvenatheodore456 Жыл бұрын

I don’t see the END on my laptop😢

@patriciathomas248 2 ай бұрын

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!

@godwinmujunisuubi4070 7 ай бұрын

you are a life saver thank you

@kjsh8able 3 жыл бұрын

Thanks, very helpful!

@deshkumar9 10 ай бұрын

Vey informative...thank you !!!

@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?

@sinannizar7273 2 жыл бұрын

Thank you so much. Love you bro

@ghiejalalon8805 Жыл бұрын

Thanks, that was helpful

@zarabullock8456 2 жыл бұрын

Saved me lots of time at work Pete! Thank you :)

@davidodundo8430 2 жыл бұрын

Saved me time. cheers

@brooklynloca1 2 жыл бұрын

Thank you so much!

@shruthishetty9188 4 ай бұрын

Thanks ! saves time !

@upendharg999 2 күн бұрын

Thank you so much

@u2focused Жыл бұрын

Thank you!

@MikeSmith-rg2cw Жыл бұрын

Thank you!!!

@kimb9362 2 жыл бұрын

Thank you! On a Mac keyboard, it's Shift+Command+Down-Arrow

@sheetalkamra6940 Жыл бұрын

Thank you

@Mosh-p5f 3 ай бұрын

Thanks for sharing

@joshuaknight1748 3 ай бұрын

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

@seongminjo8850 26 күн бұрын

For those who use Mac Key layout : Shift + Command + Arrows

@kushalappabe1975 Жыл бұрын

thank you!

@sahamsharifi5012 2 жыл бұрын

Thank you.

@zhichuren9888 2 ай бұрын

thank you so much love you

@Tjousk 3 жыл бұрын

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.

@WheeliePete 3 жыл бұрын

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.

@grahambiscuit7717 10 ай бұрын

thanks a lot!

@boystandlyim4586 3 ай бұрын

Hello Wheelie, can you please help as i don't know what did i selected and i can't use "Ctrl+Shift+Arrow up/Down". What shoul i do?

@tristanaxelino3938 2 жыл бұрын

Thank you Sir

@haleentertainment6819 Жыл бұрын

many many thank you boss

@victoriaperez4374 2 жыл бұрын

THANK YOU SIR

@MidnightLight. Ай бұрын

Thanks!

@shayan-ij5hl 6 ай бұрын

thanks that solved my problem

@priyaupadhyay7481 6 ай бұрын

Thanks brother

@ivanastogianos8683 7 ай бұрын

AMAZING!

@suguru-geto1 9 ай бұрын

Dude yu saved my time

@jamesrobertsalud1443 Жыл бұрын

Thak you very much

@ahmedbahram4653 Жыл бұрын

thanks

@bobkoshy7869 Жыл бұрын

Thanks

@shumidaw15 2 жыл бұрын

LOVE IT

@mrscaramangas 2 жыл бұрын

Thanks Bro👍🏻

@ottomoshogunate4526 Жыл бұрын

Thanks man

@DerekElliott-qn2kz 4 ай бұрын

is there a formula that can do this?

@DM-nh3zr 6 ай бұрын

Why does mine go past the end of my data?

@someless Жыл бұрын

Thanks...😊😊😊

@nizamuddenhonnekatte4237 3 ай бұрын

Thanks sir

@MC-kz1mo 2 жыл бұрын

Mine is not selecting the whole data. Its goes one at a time still

@djcandy254 3 жыл бұрын

Thanks so much for this

@jelliclesongs 3 жыл бұрын

On my mac, 1. I selected the row I wanted to start with (for deletion). 2. Then Shift + Control + down arrow. 3. Then, I right-clicked over the selection and clicked "delete."

@gaia1goddess Жыл бұрын

Is there a way to highlight only some cells? I had to split a 15,000-line Excel file into 7 and then transfer those to a new tab. Highlighting 2225 lines at a time was not fun.

@WheeliePete Жыл бұрын

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.

@ciksumurni2429 2 жыл бұрын

what if my down+arrow ruined

@tinashemukota1431 3 жыл бұрын

How to select different columns that are not side by side simultaneously? e.g. column A, C & E.

@WheeliePete 3 жыл бұрын

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.

@xs6819 Жыл бұрын

when dealing with very large files in excel do you have a way to keep the computer from freezing up?

@WheeliePete Жыл бұрын

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...

@BrownKnight15 2 ай бұрын

respect

@PrakashKumar-qo9ws 2 ай бұрын

how to use it in mac? what is the shortcut

@asmashamaileh1883 Ай бұрын

shift+control+arrow you need

@basicinfo6816 Жыл бұрын

if values are missing, in the row, how can I select the entire coloumn fast?

@WheeliePete Жыл бұрын

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.

@gopic2289 Жыл бұрын

❤

@shuda04 2 жыл бұрын

Hello, how to select a specific amount of data, for example in an excel sheet with large amount of data..i need to select like 40 rows only?

@WheeliePete 2 жыл бұрын

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.

@shuda04 2 жыл бұрын

@@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?

@Alaashaker99 Жыл бұрын

If I have like 30000 value and I want to copy only the data from 100 to 1000 without dragging, what should I do?

@WheeliePete Жыл бұрын

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.)

@user-is1is4od5m 3 ай бұрын

😊

@priyaupadhyay7481 6 ай бұрын

How to copy 10 rows data and paste in 10000 rows without dragging

@TwixtwixMC 3 жыл бұрын

you just have to press end once, not hold it down

@aravindnmdc117 2 жыл бұрын

yes

@raniasaleh3999 Жыл бұрын

Try CTRL + SPACE

@WheeliePete Жыл бұрын

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

@nishushroff9656 Жыл бұрын

How to select the entire column containing blank values too

@WheeliePete Жыл бұрын

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.

@nishushroff9656 Жыл бұрын

@@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