7 Keyboard Shortcuts For Quickly Selecting Cells And Ranges In Excel

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

[@NileshRoamingNITIAN]

Seeing a video makes life easier !!

[@truegodofthunder]

Excellent explanation. Clear and concise.

[@engtap2850]

This is what I was searching for. Lovely video

[@praveeshaksoysa1542]

Exactly wht I needed , thnx

[@peterhupka4383]

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

[@winnieip9851]

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

[@jonathanbrines9617]

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

[@ermamontano4123]

Thank you! This was exactly what I needed.

[@adysyady5527]

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

[@JingMason]

Great tips with clear concise explanations, thank you

[@ExcelCampus]

Thanks for your feedback! 😀

[@garylee143]

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

[@superjdillydillio9040]

Thank you Jon!

[@seethongyang4858]

Great help. Thank you.

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

[@rockstar-ow1kd]

Thank you exactly what I need

[@subhishk85]

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

[@anwanalam8845]

thanks bro!!! just splendid ! explicitly

[@mahdiomidali8712]

Great tutorial, thanks

[@Shazaib432]

its was awesome video to learn. Thank Mr. jon

[@matsal6680]

You're video was great,thanks!

[@laurenrider5172]

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

[@paultiefel6986]

Great video - to the point & full of content!

[@ZAHIDHUSSAIN-ri5kg]

Very helpul video...Many thanks Jon!

[@ExcelCampus]

Thank you Zahid! :-)

[@live2learnplayandtravel489]

great video

[@annmariejoshua698]

Thank you for your help

[@susanmuller161]

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

[@rajan1357]

i love you

[@nehashahpatel1741]

Millions thanks

[@alfsporturbo]

great video - thanks

[@pandumurali.n8560]

Good clearing doubts

[@Eunicorn046]

Omg finally found this video that helped me :)

[@angelagarine3295]

Thank you for sharing your tips..

[@ExcelCampus]

Thank you Angela! :-)

[@rpatade]

Thanks a lot. Saved lot of time

[@reaper331983]

Thank you.

[@hamidhajjafari9441]

Thanks a Million

[@mateofeomartinez2502]

very informative and helpful!

[@ExcelCampus]

Glad it was helpful! 😀

[@Chhexxy]

Awesome 😁💛

[@maayaavi]

Thank u so much 🥰

[@saviaabbas9753]

Good job thanks

[@paulmandal4900]

Thenks!

[@leswantht1045]

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

[@harshshah2812]

Thanks 🙏

[@l_t_truth_seeker]

Thank You

[@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! :-)

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

[@kaveri3463]

Awesome 🔥

[@ashokpanday6808]

Thank you John.

[@nadianadia6099]

👍👍👍👍 Appreciate sir really helpful

[@azarfj]

thanks a lot..!

[@manikumarpragada2441]

Tq Gurujii, Very nice Tq so much

[@bestboyofindia]

thanks dear great job

[@kalpanabista8016]

Thank you so much 🥺🥺

[@aniketthakur2248]

Nice👍👍

[@civilxpert935]

THANK YOU SIR IT HELP ME VERY MUCH.

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

[@mrpips76]

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

[@brandonspiegel2293]

Thanks for the help!!!!

[@ExcelCampus]

Thanks Brandon! 🙂

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

[@chinmeyjain4559]

exactly what i required

[@shahzadasmat6638]

thumbs up...thanks

[@nagarajuvivahabojanambu5366]

VERY USEFUL VIDEO THANKING YOU SIR

[@kolfarm1one995]

Ctrl+Shift +Arrow is the most useful

[@THESKILLEVENT]

Really helpful!

[@RA-rh5lb]

Thanks

[@danielblank497]

Thank-you! This is really helpful.

[@lanettfielder8050]

Thank that was insightful much appreciated.

[@mohamedlemineheyine2818]

Thank you so much, this video is very helpfull.

[@ExcelCampus]

Thank you Mohamed! :-)

[@zainshuja8454]

Excellent

[@peytono727]

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

[@chancolallvideo]

This is good video

[@KingOfKingz4736.]

Life Saver....

[@meloyler9318]

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

[@bradgoehl]

Thanks for making this video, it helped me!

[@juanm.aguayo-leal9795]

EXCELLENT !!!! THANK YOU!

[@abdallahmortada8954]

Super Cool!

[@aniketthakur2248]

Thnx🙏

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

[@giwrgosdas]

ooooo that was sooo liberated

[@nagarajuv8631]

Super sir

[@manojillangasooriya3590]

love it

[@xxviking1999xx]

Awesome

[@maheshrathod204]

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

[@ronjones1308]

'Thank you very much!!

[@lyndadaud85]

TQ

[@PankajKumar-gy4kx]

thanks sir!!!

[@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! :-)

[@higheringai68]

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

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

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

[@shirke01]

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

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

[@ruiwc2561]

You can select full row or collumn if you click on Thr numbers or letters. But how do I do it with the keyboard ?

[@joel_pm]

Ctrl + Spacebar to select column, Shift + Spacebar to select row

[@maosongnguon2244]

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

[@filwen6913]

Thanks!! It was very helpful 😀

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

[@d-linquent2675]

How to select range of large data while typing formula....while typing a formula I have to use mouse and thats inconvenient

[@basicinfo6816]

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

[@joel_pm]

Ctrl + Spacebar

[@sanjeevpandey1345]

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

[@pawansingh-ke4qk]

Sir ,I need pdf .

[@isaacjacobharris]

Fun fact, use Ctrl + Shift + 8 to select the whole connected table.