7 Keyboard Shortcuts For Quickly Selecting Cells And Ranges In Excel

[@truegodofthunder]

Excellent explanation. Clear and concise.

[@NileshRoamingNITIAN]

Seeing a video makes life easier !!

[@mommygooglybae9996]

Thank you so much save me me so much time today at work

[@chitownfisherman]

Awesome man. Searched the internet far and wide and finally found some tricks that work in this video. Thanks!

[@engtap2850]

This is what I was searching for. Lovely video

[@praveeshaksoysa1542]

Exactly wht I needed , thnx

[@jonathanbrines9617]

Love using shortcuts and hot keys
Thanks!!
Good content. Audible commentary.

[@subhishk85]

Thank you very much for this ...really useful video.

[@peterhupka4383]

Thanks for the hints, it help me to be faster than before

[@ermamontano4123]

Thank you! This was exactly what I needed.

[@JingMason]

Great tips with clear concise explanations, thank you

[@ExcelCampus]

Thanks for your feedback! 😀

[@Shazaib432]

its was awesome video to learn. Thank Mr. jon

[@anwanalam8845]

thanks bro!!! just splendid ! explicitly

[@winnieip9851]

thanks Jon. You help me a lot with my recent data analyses project that involve large datasets.

[@adysyady5527]

Thanks u just saved me lot of times to do my work!! 😭

[@matsal6680]

You're video was great,thanks!

[@seethongyang4858]

Great help. Thank you.

[@garylee143]

useful. I am totally blind, so keyboard access is crucial. I'll take all of this I can get. thank you very much.

[@ZAHIDHUSSAIN-ri5kg]

Very helpul video...Many thanks Jon!

[@ExcelCampus]

Thank you Zahid! :-)

[@rockstar-ow1kd]

Thank you exactly what I need

[@katieloughrist]

Awesome! Incredibly helpful! My mouth was agape the whole time I was watching this! One question: Do you know why it might be the case that when I attempt the Ctrl + End function, it takes me to a last used cell that I can't figure out how to delete? You showed how to delete the unused rows, but no matter what I delete (the column or the row), it still selects this same cell as the END. Thanks again for your help!

[@mateofeomartinez2502]

very informative and helpful!

[@ExcelCampus]

Glad it was helpful! 😀

[@superjdillydillio9040]

Thank you Jon!

[@Eunicorn046]

Omg finally found this video that helped me :)

[@mahdiomidali8712]

Great tutorial, thanks

[@live2learnplayandtravel489]

great video

[@alfsporturbo]

great video - thanks

[@annmariejoshua698]

Thank you for your help

[@nadianadia6099]

👍👍👍👍 Appreciate sir really helpful

[@rpatade]

Thanks a lot. Saved lot of time

[@paultiefel6986]

Great video - to the point & full of content!

[@angelagarine3295]

Thank you for sharing your tips..

[@ExcelCampus]

Thank you Angela! :-)

[@pandumurali.n8560]

Good clearing doubts

[@susanmuller161]

Very good info. Your easy to listen to and answered all my questions. Do you tutor?

[@rajan1357]

i love you

[@leswantht1045]

Thanks Sir. It really helped for me. Saves Lot of time.

[@livebiochemistry]

V useful video...will save lot of time.. tx@excel campus -Jon tx @youtube for suggestion

[@laurenrider5172]

Thank you! I always learn something new from your videos!! I also find it easy to remember. Ctrl+A is my new favorite. :)

[@bestboyofindia]

thanks dear great job

[@Chhexxy]

Awesome 😁💛

[@maayaavi]

Thank u so much 🥰

[@nehashahpatel1741]

Millions thanks

[@mohamedlemineheyine2818]

Thank you so much, this video is very helpfull.

[@ExcelCampus]

Thank you Mohamed! :-)

[@kalpanabista8016]

Thank you so much 🥺🥺

[@saviaabbas9753]

Good job thanks

[@AishHumairaa]

Thank you so much ! Really helpful 😊

[@manikumarpragada2441]

Tq Gurujii, Very nice Tq so much

[@hamidhajjafari9441]

Thanks a Million

[@civilxpert935]

THANK YOU SIR IT HELP ME VERY MUCH.

[@brandonspiegel2293]

Thanks for the help!!!!

[@ExcelCampus]

Thanks Brandon! 🙂

[@reaper331983]

Thank you.

[@kaveri3463]

Awesome 🔥

[@azarfj]

thanks a lot..!

[@salnaud8898]

Thank you very much for your tutorial.
What ever which makes me faster working with excel could be helpful (Specially keyboard shortcuts).
Thank you very much for all the efforts.
Please make a video related to shortcuts of plotting graphs.
Cheers,

[@chancolallvideo]

This is good video

[@nagarajuvivahabojanambu5366]

VERY USEFUL VIDEO THANKING YOU SIR

[@aniketthakur2248]

Nice👍👍

[@meloyler9318]

Very Helpful
I'm going to recommend to others. mel

[@harshshah2812]

Thanks 🙏

[@kelliburdette6410]

I have learned SO much helpful and valuable tricks and shortcuts from Jon and his videos! Check out Excel Campus!!!!

[@ExcelCampus]

Thanks so much Kelli! I really appreciate your support and happy to hear you are learning more about Excel. Have a great day! :-)

[@mrpips76]

Thank you so much John. You saved me tons of time!

[@ashokpanday6808]

Thank you John.

[@paulmandal4900]

Thenks!

[@l_t_truth_seeker]

Thank You

[@shahzadasmat6638]

thumbs up...thanks

[@bradgoehl]

Thanks for making this video, it helped me!

[@THESKILLEVENT]

Really helpful!

[@juanm.aguayo-leal9795]

EXCELLENT !!!! THANK YOU!

[@maythamalmouthen5191]

Thanks ... Great Video.
Just want to know, If I select full column with Ctrl+Shift+Down Arrow Key, How can I jump back to the first cell in the selected column without losing the selection. Jump with keyboard short cuts not by using mouse please.

[@zainshuja8454]

Excellent

[@LondonA2Z]

Hey buddy. many thanks for your useful videos. How can we select the previous cells in a column or row? For example, I would like to have: "sum(A2:A1) in B2", "sum(A3:A1) in B3", "sum(A4:A1) in B4" and so on. In the common drag and drop, we will not have the desired format.

[@elynn1100]

Many thanks. I have had problems with a macro crashing while selecting three columns. By using a combination of your ctl+shift commands - problem solved.

[@ExcelCampus]

Thanks Elynn! :-)

[@abdallahmortada8954]

Super Cool!

[@manojillangasooriya3590]

love it

[@chinmeyjain4559]

exactly what i required

[@kolfarm1one995]

Ctrl+Shift +Arrow is the most useful

[@nagarajuv8631]

Super sir

[@KingOfKingz4736.]

Life Saver....

[@giwrgosdas]

ooooo that was sooo liberated

[@jomohund]

Good video here! I’m forever adding and deleting columns and rows in worksheets, so I use ctrl+space and shift+space to select a full column or row, then use ctrl+ ‘+’ to insert a row or ctrl+’-‘ to delete.

[@ExcelCampus]

Great suggestion John! I use those shortcuts all the time too. Here is an article I have on 5 keyboard shortcuts for rows and columns. (www.excelcampus.com/keyboard-shortcuts/row-and-column-shortcuts/), that includes the Ctrl+'+' and Ctrl+'-'. I will create a video on those in the future as well. Thanks again! :-)

[@THESKILLEVENT]

You can also add Column by "alt+i+c" in excel 2010 onwards, to add raw "alt+i+r"

[@aniketthakur2248]

Thnx🙏

[@RA-rh5lb]

Thanks

[@filwen6913]

Thanks!! It was very helpful 😀

[@ronjones1308]

'Thank you very much!!

[@xxviking1999xx]

Awesome

[@peytono727]

Select your first data entry in the column, control + shift + down arrow
You’re welcome
For large data columns without selecting the header

[@PankajKumar-gy4kx]

thanks sir!!!

[@maheshrathod204]

thenks mate i almost forgot that cont+shift trick I was very angry and curious that which key I have to press

[@madcapper6]

How do you select two different non-adjacent blocks of cells at the same time? Like a3-a7, then select d3-d7 while a3-a7 remains selected?

[@poyjuarez7670]

Press Ctrl then right click 1 by 1.

[@madcapper6]

@@poyjuarez7670 Thank you. I'll give it a try. Good day to you.

[@lyndadaud85]

TQ

[@maosongnguon2244]

why Shift +Ctrl+Key down not work ,Can you tell me ,in Excel 2018 thanks !

[@tarunkumarguptaiimjammu334]

👍🏻👍🏻

[@TheJohnnyB0i1]

When I'm working with a large dataset and I want to enter a whole column in a formula, it scrolls my excel all the way down of the page after using the excel shortcut ctrl + shift + down arrow. Is there a way to prevent that or is there a way to scroll all the way back up with a shortcut?

[@higheringai68]

Dell laptop Inspiron 13 - 7359 - what if the 'End' and 'right arrow' are on the same key?

[@nemoexplore857]

If i have 300x20 in one cell or 300x100 or 300x1111 I want to extract what holds after x how can i do that what is the formula for that. I cant use right function for that so how can i do that

[@daomai9915]

Question when I hold Ctri + End. It doesn't move the key to the end of the sheet but the end of the row. Can you please let me know why? Thanks

[@jahanzaibshahid9372]

PLZ INFORM HOW TO CHANGE EXCEL SETTING FOR GO TO LINKED CELL DESTINATION BY USING MOUSE SINGLE CLICK INSTEAD OF USING KEY BOARD SHORT CUT CTRL+[ .

[@SanviPatil2019]

Sir i have need help you, i have one excel workbook ..inthis workbook multiple sheet, i have find data multiple sheet in the one sheet,

[@secretarytreasurerlocal4093]

Your voice is great and I would love to subscribe but I am a mac user and you refer only to PC...for example END key, Mac does not have one

[@sanjeevpandey1345]

Sir what can I do when ctrl+shift+arrow key is not working in my laptop

[@shirke01]

How to save it column and row so next time I open excel open same exact way