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

No video

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

Рет қаралды 283,815

4 жыл бұрын

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.

Пікірлер: 119

@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 4 ай бұрын

If there is a blank cell selection stops there

@alexrivera7598 3 жыл бұрын

I use ctr shift arrow

@celseac8107 2 жыл бұрын

This worked for me too!

@prayashpanda7884 2 жыл бұрын

thank you!

@ricklemanczyk2966 3 жыл бұрын

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

@navdeepdhillon4764 3 ай бұрын

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

@marvenatheodore456 Жыл бұрын

I don’t see the END on my laptop😢

@patriciathomas248 3 ай бұрын

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!

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

Ur concise info is worth to watch.

@Tjousk 4 жыл бұрын

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 4 жыл бұрын

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.

@eddieeriksson5830 5 ай бұрын

Saved me a lot of frustration! Thank you!

@joshuaknight1748 4 ай бұрын

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

@venkatprabhu2057 3 жыл бұрын

exactly what i searched for thank you

@akosibon4907 11 күн бұрын

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

@nickt609 3 күн бұрын

you are amazing bro thanks

@gregjerry4110 3 ай бұрын

Thats one headache permanently cured 👍

@AnomalyBelleza 6 ай бұрын

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

@NorthFloridaLiving Ай бұрын

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

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

Why does mine go past the end of my data?

@gazimahfuj9147 2 ай бұрын

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

@peterslaby9782 6 күн бұрын

Thanks bro!

@seongminjo8850 2 ай бұрын

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

@nurmanisajid8714 Ай бұрын

Thank a lot very helpful.

@godwinmujunisuubi4070 8 ай бұрын

you are a life saver thank you

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

@zarabullock8456 2 жыл бұрын

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

@turki3289 10 ай бұрын

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

@ATPhilippines Жыл бұрын

Thanks for this , this helped me in my work!

@telaadvisor Жыл бұрын

You just save my day; thank you.

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

@kimb9362 2 жыл бұрын

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

@DirtyDanGamingYT Жыл бұрын

Thank you this is what I needed!

@glovespaulo1342 2 жыл бұрын

Thank you this short video helped

@louiefelecio746 2 ай бұрын

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

@KhairiDarweesh Жыл бұрын

That's very helpful, thank you!

@sinannizar7273 2 жыл бұрын

Thank you so much. Love you bro

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

Thank you so much

@hercules1345 2 ай бұрын

Awesome trick. Thank you very much.

@deshkumar9 11 ай бұрын

Vey informative...thank you !!!

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

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

@bongiperez7565 11 ай бұрын

Most succint video. Thank You!

@boystandlyim4586 5 ай бұрын

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?

@kjsh8able 3 жыл бұрын

Thanks, very helpful!

@fluidlevels Жыл бұрын

THANK YOU!

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

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

Thanks for sharing

@davidodundo8430 2 жыл бұрын

Saved me time. cheers

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

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

@shruthishetty9188 6 ай бұрын

Thanks ! saves time !

@brooklynloca1 2 жыл бұрын

Thank you so much!

@LyLeinUS 10 ай бұрын

thank you, that helps a lot!

@aravindnmdc117 2 жыл бұрын

Thank you

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

@uai-anchow98 Жыл бұрын

Thank you!

@zhichuren9888 4 ай бұрын

thank you so much love you

@ghiejalalon8805 Жыл бұрын

Thanks, that was helpful

@ahmedbahram4653 Жыл бұрын

thanks

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

Dude yu saved my time

@1o9s7 Жыл бұрын

Thank you!!!

@RehanAnsari-xy4ct 3 жыл бұрын

Thanks!

@sahamsharifi5012 2 жыл бұрын

Thank you.

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

is there a formula that can do this?

@priyaupadhyay7481 8 ай бұрын

Thanks brother

@victoriaperez4374 2 жыл бұрын

THANK YOU SIR

@tristanaxelino3938 2 жыл бұрын

Thank you Sir

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

how to use it in mac? what is the shortcut

@asmashamaileh1883 3 ай бұрын

shift+control+arrow you need

@grahambiscuit7717 Жыл бұрын

thanks a lot!

@kushalappabe1975 Жыл бұрын

thank you!

@hafolahbi 2 жыл бұрын

Thanks

@djcandy254 3 жыл бұрын

Thanks so much for this

@shumidaw15 3 жыл бұрын

LOVE IT

@shayan-mlj 8 ай бұрын

thanks that solved my problem

@ivanastogianos8683 8 ай бұрын

AMAZING!

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

@nizamuddenhonnekatte4237 4 ай бұрын

Thanks sir

@jamesrobertsalud1443 Жыл бұрын

Thak you very much

@someless Жыл бұрын

Thanks...😊😊😊

@haleentertainment6819 Жыл бұрын

many many thank you boss

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

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

@ciksumurni2429 2 жыл бұрын

what if my down+arrow ruined

@mrscaramangas 2 жыл бұрын

Thanks Bro👍🏻

@ottomoshogunate4526 Жыл бұрын

Thanks man

@TwixtwixMC 3 жыл бұрын

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

@aravindnmdc117 2 жыл бұрын

yes

@gopic2289 Жыл бұрын

❤

@priyaupadhyay7481 8 ай бұрын

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

@BrownKnight15 4 ай бұрын

respect

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

😊

@raniasaleh3999 Жыл бұрын

Try CTRL + SPACE

@WheeliePete Жыл бұрын

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

@nishushroff9656 2 жыл бұрын

How to select the entire column containing blank values too

@WheeliePete 2 жыл бұрын

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 2 жыл бұрын

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