7 Keyboard Shortcuts For Quickly Selecting Cells And Ranges In Excel

7 keyboard shortcuts (plus variations) on how to select cells and ranges on a worksheet.
-- LINKS --
DOWNLOAD THE WORKBOOK ► www.excelcampus.com/keyboard-...
** JOIN OUR COMPREHENSIVE EXCEL TRAINING PROGRAM**
www.excelcampus.com/join-elevate
--
~ Learn my BLUEPRINT for Excel including when to use what tool (FREE TRAINING SESSION) www.excelcampus.com/blueprint ~
~Become an Excel Campus Insider (100% free) to access advanced workshops, bonus training, and weekly Excel tips: www.excelcampus.com/newsletter/
In this video I share 7 keyboard shortcuts (plus variations) on how to select cells and ranges on a worksheet. These save time with navigating the worksheet, especially when working with large data sheets.
Here are the main keyboard shortcuts.
1. Select Last Used Cell on the Sheet: Ctrl+End (0:15)
2. Select First Cell on the Sheet: Ctrl+Home (1:33)
3. Select Last Used Cell in a Range: Ctrl+Arrow Keys (2:02)
4. Select Multiple Cells: Shift+Arrow Keys (3:19)
5. Select Range of Used Cells in Row/Column: Ctrl+Shift+Arrow Keys (3:47)
6. Select Entire Range of Used Cells: Ctrl+Shift+Home/End (4:54)
7. Select All Cells in a Used Range: Ctrl+A (5:34)
I also explain variations and how each of these shortcuts works in different situations.
**********
EXCEL FRIENDLY ACCESSORIES WE USE (Affiliate Links When Possible): LOGITECH KEYBOARD
Check out all the tech we use and recommend at www.excelcampus.com/store
**********
-- Related Content --
- 8 Keyboard Shortcuts for the VBA Editor in Excel: • 8 Awesome Keyboard Sho...
- 2 Keyboard Shortcuts to Select a Column with Blank Cells in Excel: • Selecting A Column Wit...
- Excel Filters Training - Keyboard Shortcuts - Part 2 of 3: • Excel Filters Training...
- Excel Shortcut to Select Rows or Columns with Blanks Cells by Moving Selection: • Excel Shortcut to Sele...
#MicrosoftExcel #MSExcel #KZbinForLearning #excelcharts

[@NileshRoamingNITIAN]

Seeing a video makes life easier !!

[@laurenrider5172]

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

[@chitownfisherman]

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

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

[@paulmandal4900]

Thenks!

[@mrpips76]

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

[@mommygooglybae9996]

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

[@ermamontano4123]

Thank you! This was exactly what I needed.

[@jonathanbrines9617]

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

[@praveeshaksoysa1542]

Exactly wht I needed , thnx

[@mrCetus]

This is what I was searching for. Lovely video

[@winnieip9851]

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

[@paultiefel6986]

Great video - to the point & full of content!

[@bradgoehl]

Thanks for making this video, it helped me!

[@leswantht1045]

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

[@saviaabbas9753]

Good job thanks

[@manikumarpragada2441]

Tq Gurujii, Very nice Tq so much

[@THESKILLEVENT]

Really helpful!

[@peterhupka4383]

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

[@juanm.aguayo-leal9795]

EXCELLENT !!!! THANK YOU!

[@azarfj]

thanks a lot..!

[@danielblank497]

Thank-you! This is really helpful.

[@lanettfielder8050]

Thank that was insightful much appreciated.

[@superjdillydillio9040]

Thank you Jon!

[@ZAHIDHUSSAIN-ri5kg]

Very helpul video...Many thanks Jon!

[@ExcelCampus]

Thank you Zahid! :-)

[@adysyady5527]

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

[@civilxpert935]

THANK YOU SIR IT HELP ME VERY MUCH.

[@livebiochemistry]

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

[@matsal6680]

You're video was great,thanks!

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

[@rpatade]

Thanks a lot. Saved lot of time

[@anwanalam8845]

thanks bro!!! just splendid ! explicitly

[@seethongyang4858]

Great help. Thank you.

[@kalpanabista8016]

Thank you so much 🥺🥺

[@bestboyofindia]

thanks dear great job

[@garylee143]

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

[@nehashahpatel1741]

Millions thanks

[@nagarajuvivahabojanambu5366]

VERY USEFUL VIDEO THANKING YOU SIR

[@rockstar-ow1kd]

Thank you exactly what I need

[@subhishk85]

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

[@user-eu1ry9ci2g]

Great tips with clear concise explanations, thank you

[@ExcelCampus]

Thanks for your feedback! 😀

[@mahdiomidali8712]

Great tutorial, thanks

[@KingOfKingz4736.]

Life Saver....

[@gehadmayhoub8489]

Thank you

[@annmariejoshua698]

Thank you for your help

[@aniketthakur2248]

Nice👍👍

[@ashokpanday6808]

Thank you John.

[@hamidhajjafari9441]

Thanks a Million

[@Eunicorn046]

Omg finally found this video that helped me :)

[@pandumurali.n8560]

Good clearing doubts

[@angelagarine3295]

Thank you for sharing your tips..

[@ExcelCampus]

Thank you Angela! :-)

[@mohamedlemineheyine2818]

Thank you so much, this video is very helpfull.

[@ExcelCampus]

Thank you Mohamed! :-)

[@meloyler9318]

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

[@reaper331983]

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!

[@Shazaib432]

its was awesome video to learn. Thank Mr. jon

[@aniketthakur2248]

Thnx🙏

[@nagarajuv8631]

Super sir

[@alfsporturbo]

great video - thanks

[@RA-rh5lb]

Thanks

[@ronjones1308]

'Thank you very much!!

[@l_t_truth_seeker]

Thank You

[@manojillangasooriya3590]

love it

[@harshshah2812]

Thanks 🙏

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

[@maayaavi]

Thank u so much 🥰

[@chinmeyjain4559]

exactly what i required

[@chancolallvideo]

This is good video

[@PankajKumar-gy4kx]

thanks sir!!!

[@kaveri3463]

Awesome 🔥

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

[@giwrgosdas]

ooooo that was sooo liberated

[@abdallahmortada8954]

Super Cool!

[@susanmuller161]

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

[@rajan1357]

i love you

[@filwen6913]

Thanks!! It was very helpful 😀

[@nadianadia6099]

👍👍👍👍 Appreciate sir really helpful

[@Chhexxy]

Awesome 😁💛

[@brandonspiegel2293]

Thanks for the help!!!!

[@ExcelCampus]

Thanks Brandon! 🙂

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

[@kolfarm1one995]

Ctrl+Shift +Arrow is the most useful

[@mateofeomartinez2502]

very informative and helpful!

[@ExcelCampus]

Glad it was helpful! 😀

[@live2learnplayandtravel489]

great video

[@lyndadaud85]

TQ

[@shahzadasmat6638]

thumbs up...thanks

[@akyjaiawal6504]

Awesome

[@zainshuja8454]

Excellent

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

[@AishHumairaa]

Thank you so much ! Really helpful 😊

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

[@maheshrathod204]

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

[@higheringai68]

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

[@maosongnguon2244]

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

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

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

[@sanjeevpandey1345]

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

[@tarunkumarguptaiimjammu334]

👍🏻👍🏻

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

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

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

[@shirke01]

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

[@peytono727]

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