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

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

WheeliePete

3 года назад

263,896 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@ivanastogianos8683
@ivanastogianos8683 - 28.11.2023 01:40

AMAZING!

Ответить
@godwinmujunisuubi4070
@godwinmujunisuubi4070 - 25.11.2023 17:47

you are a life saver thank you

Ответить
@turki3289
@turki3289 - 01.10.2023 16:45

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

Ответить
@LyLeinUS
@LyLeinUS - 29.09.2023 18:44

thank you, that helps a lot!

Ответить
@suguru-geto1
@suguru-geto1 - 13.09.2023 17:04

Dude yu saved my time

Ответить
@deshkumar9
@deshkumar9 - 29.08.2023 17:52

Vey informative...thank you !!!

Ответить
@bongiperez7565
@bongiperez7565 - 23.08.2023 16:12

Most succint video. Thank You!

Ответить
@grahambiscuit7717
@grahambiscuit7717 - 15.08.2023 05:12

thanks a lot!

Ответить
@fluidlevels
@fluidlevels - 28.07.2023 18:12

THANK YOU!

Ответить
@someless
@someless - 03.07.2023 11:53

Thanks...😊😊😊

Ответить
@ATPhilippines
@ATPhilippines - 11.05.2023 10:33

Thanks for this , this helped me in my work!

Ответить
@ghiejalalon8805
@ghiejalalon8805 - 27.04.2023 10:02

Thanks, that was helpful

Ответить
@sheetalkamra6940
@sheetalkamra6940 - 10.03.2023 10:54

Thank you

Ответить
@jamesrobertsalud1443
@jamesrobertsalud1443 - 19.02.2023 02:56

Thak you very much

Ответить
@kushalappabe1975
@kushalappabe1975 - 08.02.2023 02:02

thank you!

Ответить
@MikeSmith-rg2cw
@MikeSmith-rg2cw - 04.01.2023 03:25

Thank you!!!

Ответить
@u2focused
@u2focused - 24.12.2022 08:50

Thank you!

Ответить
@Tiago.Bernardino
@Tiago.Bernardino - 16.12.2022 23:54

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?

Ответить
@gaia1goddess
@gaia1goddess - 14.12.2022 17:58

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.

Ответить
@bobkoshy7869
@bobkoshy7869 - 13.12.2022 06:54

Thanks

Ответить
@xs6819
@xs6819 - 10.12.2022 08:19

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

Ответить
@sebastiangarcia4057
@sebastiangarcia4057 - 09.12.2022 00:11

goat

Ответить
@KhairiDarweesh
@KhairiDarweesh - 04.12.2022 06:31

That's very helpful, thank you!

Ответить
@ahmedbahram4653
@ahmedbahram4653 - 27.11.2022 15:01

thanks

Ответить
@Alaa-ub7ry
@Alaa-ub7ry - 21.11.2022 18:15

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

Ответить
@telaadvisor
@telaadvisor - 20.11.2022 11:46

You just save my day; thank you.

Ответить
@ottomoshogunate4526
@ottomoshogunate4526 - 13.11.2022 14:52

Thanks man

Ответить
@marvenatheodore456
@marvenatheodore456 - 08.11.2022 20:26

I don’t see the END on my laptop😢

Ответить
@omarsa160
@omarsa160 - 26.10.2022 01:37

Thank you!!!

Ответить
@DirtyDanGamingYT
@DirtyDanGamingYT - 23.10.2022 21:38

Thank you this is what I needed!

Ответить
@uai-anchow98
@uai-anchow98 - 18.10.2022 17:37

Thank you!

Ответить
@haleentertainment6819
@haleentertainment6819 - 21.09.2022 19:06

many many thank you boss

Ответить
@gopic2289
@gopic2289 - 20.09.2022 00:07

Ответить
@basicinfo6816
@basicinfo6816 - 31.08.2022 00:09

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

Ответить
@raniasaleh3999
@raniasaleh3999 - 27.08.2022 16:20

Try CTRL + SPACE

Ответить
@nishushroff9656
@nishushroff9656 - 04.08.2022 13:37

How to select the entire column containing blank values too

Ответить
@pamelarachil3730
@pamelarachil3730 - 08.07.2022 22:05

THANK YOU!!!!

Ответить
@sahamsharifi5012
@sahamsharifi5012 - 13.06.2022 16:58

Thank you.

Ответить
@hafolahbi
@hafolahbi - 13.06.2022 14:19

Thanks

Ответить
@brooklynloca1
@brooklynloca1 - 19.05.2022 16:42

Thank you so much!

Ответить
@victoriaperez4374
@victoriaperez4374 - 02.05.2022 21:28

THANK YOU SIR

Ответить
@tristanaxelino3938
@tristanaxelino3938 - 07.04.2022 06:03

Thank you Sir

Ответить
@loagahoo1
@loagahoo1 - 02.04.2022 12:28

shift + Ctrl and down arrow works.

Ответить
@ciksumurni2429
@ciksumurni2429 - 11.03.2022 11:25

what if my down+arrow ruined

Ответить
@MC-kz1mo
@MC-kz1mo - 23.02.2022 20:03

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

Ответить
@zarabullock8456
@zarabullock8456 - 11.02.2022 16:57

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

Ответить
@kimb9362
@kimb9362 - 09.02.2022 10:52

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

Ответить
@mrscaramangas
@mrscaramangas - 13.01.2022 15:36

Thanks Bro👍🏻

Ответить
@MaheshKumar-en5yh
@MaheshKumar-en5yh - 08.01.2022 10:29

Ur concise info is worth to watch.

Ответить
@glovespaulo1342
@glovespaulo1342 - 23.12.2021 11:56

Thank you this short video helped

Ответить