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

[@ricklemanczyk2966]

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

[@tonymulon5009]

Thanks alot bro. This helped me a lot.

[@loagahoo1]

shift + Ctrl and down arrow works.

[@mohsin_raz]

thank you!

[@josspeace9841]

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

[@Moondisapear]

Thank you 🌸🌹❤️

[@pearlmeyy1786]

You saved me!!!!

[@vamanshenoy938]

If there is a blank cell selection stops there

[@eddieeriksson5830]

Saved me a lot of frustration! Thank you!

[@MaheshKumar-en5yh]

Ur concise info is worth to watch.

[@navdeepdhillon4764]

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

[@venkatprabhu2057]

exactly what i searched for thank you

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

[@WheeliePete]

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.

[@AnomalyBelleza]

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

[@alexrivera7598]

I use ctr shift arrow

[@celseac8107]

This worked for me too!

[@prayashpanda7884]

thank you!

[@JaimieSigamoney]

Thank you 🎉🎉🎉 you saved me alot of time

[@RobinFriedrich-g6b]

Yes, Control+a selects the entire table, this trick does best if you want just select columns. In my case I needed the table not the complete worksheet.

[@marvenatheodore456]

I don’t see the END on my laptop😢

[@patriciathomas248]

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!

[@zarabullock8456]

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

[@akosibon4907]

New update guys just hit button: "SHIFT+CTRL THEN DOWN" Your welcome :)

[@nickt609]

you are amazing bro thanks

[@nerima1275]

Thank you so much!!

[@jeffhoward5076]

Solid, shift end down wasn’t working, this does

[@md.touhidulislam4644]

THANKS BRO

[@mixzsv4239]

saved me a lot of time thank you bro

[@NorthFloridaLiving]

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

[@gazimahfuj9147]

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

[@joshuaknight1748]

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

[@ATPhilippines]

Thanks for this , this helped me in my work!

[@gregjerry4110]

Thats one headache permanently cured 👍

[@telaadvisor]

You just save my day; thank you.

[@turki3289]

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

[@seongminjo8850]

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

[@sadddge2067]

Thanks man

[@godwinmujunisuubi4070]

you are a life saver thank you

[@DirtyDanGamingYT]

Thank you this is what I needed!

[@jelliclesongs]

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

[@KhairiDarweesh]

That's very helpful, thank you!

[@sinannizar7273]

Thank you so much. Love you bro

[@DM-nh3zr]

Why does mine go past the end of my data?

[@RushinxtLF]

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

[@glovespaulo1342]

Thank you this short video helped

[@kimb9362]

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

[@hercules1345]

Awesome trick. Thank you very much.

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

[@bongiperez7565]

Most succint video. Thank You!

[@davidodundo8430]

Saved me time. cheers

[@boystandlyim4586]

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?

[@deshkumar9]

Vey informative...thank you !!!

[@tinashemukota1431]

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

[@WheeliePete]

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.

[@Daniel-dj7fh]

Assuming my column A has a whole year spread out in 15min intervals, meaning for example one day has like around 100 lines, and a month 3000 lines roughly. How do I find out where one month starts and ends, and then mark the data of the month to lets say make a graph (it's got 3 whole columns of data, A: date, B: minute, C: Value for graph)

[@kjsh8able]

Thanks, very helpful!

[@LyLeinUS]

thank you, that helps a lot!

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

[@yingying202mai]

What about selecting all rows in multiple, but non-consecutive columns? Is there a way to do that?

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

[@MC-kz1mo]

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

[@shruthishetty9188]

Thanks ! saves time !

[@tehreemfatima5039]

Your voice is soo attractive..

[@londonlifts1044]

Does anyone know why when you click Shift + Control down on the arrows that some of the data will disappear on the way down or up?

[@nurmanisajid8714]

Thank a lot very helpful.

[@shuda04]

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]

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]

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

[@suguru-geto1]

Dude yu saved my time

[@DerekElliott-qn2kz]

is there a formula that can do this?

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

[@PrakashKumar-qo9ws]

how to use it in mac? what is the shortcut

[@asmashamaileh1883]

shift+control+arrow you need

[@ghiejalalon8805]

Thanks, that was helpful

[@NSGLiv]

Thank you for this video

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

[@RobinFriedrich-g6b]

How about Control+a

[@ciksumurni2429]

what if my down+arrow ruined

[@Mosh-p5f]

Thanks for sharing

[@zhichuren9888]

thank you so much love you

[@ProdiptoAdhikary]

Thank you so much

[@brooklynloca1]

Thank you so much!

[@TwixtwixMC]

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

[@aravindnmdc117]

yes

[@someless]

Thanks...😊😊😊

[@shayan-mlj]

thanks that solved my problem

[@uai-anchow98]

Thank you!

[@mrscaramangas]

Thanks Bro👍🏻

[@djcandy254]

Thanks so much for this

[@ivanastogianos8683]

AMAZING!

[@peterslaby9782]

Thanks bro!

[@pamelarachil3730]

THANK YOU!!!!

[@roselinedilsukh3616]

Thank you

[@victoriaperez4374]

THANK YOU SIR

[@priyaupadhyay7481]

Thanks brother

[@shumidaw15]

LOVE IT

[@tristanaxelino3938]

Thank you Sir

[@sahamsharifi5012]

Thank you.

[@RehanAnsari-xy4ct]

Thanks!

[@haleentertainment6819]

many many thank you boss

[@HindSena-005]

Ctrl + Shift + SpaceBar

[@HindSena-005]

Ctrl + Shift + End

[@HindSena-005]

Ctrl + Shift + Down Arrow

[@priyaupadhyay7481]

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

[@nizamuddenhonnekatte4237]

Thanks sir

[@NazmulHasan-ex5wv]

thanks

[@jamesrobertsalud1443]

Thak you very much

[@ottomoshogunate4526]

Thanks man

[@gopic2289]

❤

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

[@BrownKnight15]

respect

[@md.touhidulislam4644]

THANK YOU

[@1o9s7]

Thank you!!!

[@aravindnmdc117]

Thank you

[@u2focused]

Thank you!

[@grahambiscuit7717]

thanks a lot!

[@MidnightLight.]

Thanks!

[@candlestickstoldthestory3570]

Thanks

[@upendharg999]

Thank you so much

[@fluidlevels]

THANK YOU!