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.excelcampu...
** JOIN OUR COMPREHENSIVE EXCEL TRAINING PROGRAM**
www.excelcampu...
--
~ Learn my BLUEPRINT for Excel including when to use what tool (FREE TRAINING SESSION) www.excelcampu... ~
~Become an Excel Campus Insider (100% free) to access advanced workshops, bonus training, and weekly Excel tips: www.excelcampu...
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.excelcampu...
**********
-- 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 !!

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

[@garylee143]

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

[@subhishk85]

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

[@susanmuller161]

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

[@rajan1357]

i love you

[@Shazaib432]

its was awesome video to learn. Thank Mr. jon

[@rockstar-ow1kd]

Thank you exactly what I need

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

[@mateofeomartinez2502]

very informative and helpful!

[@ExcelCampus]

Glad it was helpful! 😀

[@alfsporturbo]

great video - thanks

[@bradgoehl]

Thanks for making this video, it helped me!

[@chancolallvideo]

This is good video

[@juanm.aguayo-leal9795]

EXCELLENT !!!! THANK YOU!

[@saviaabbas9753]

Good job thanks

[@manikumarpragada2441]

Tq Gurujii, Very nice Tq so much

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

[@paulmandal4900]

Thenks!

[@KingOfKingz4736.]

Life Saver....

[@maheshrathod204]

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

[@shahzadasmat6638]

thumbs up...thanks

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

[@livebiochemistry]

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

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

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

[@praveeshaksoysa1542]

Exactly wht I needed , thnx

[@maosongnguon2244]

why Shift +Ctrl+Key down not work ,Can you tell me ,in Excel 2018 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

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

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

[@jahangeermuhammadreshi3828]

How to select 3 coloums out of 5 in excel using short cut key

[@AKGAMING8310]

Hello I am an Indian

[@sharmilabanu2021]

,

[@chitownfisherman]

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

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

[@ermamontano4123]

Thank you! This was exactly what I needed.

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

[@laurenrider5172]

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

[@mommygooglybae9996]

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

[@azarfj]

thanks a lot..!

[@tarunkumarguptaiimjammu334]

👍🏻👍🏻

[@aniketthakur2248]

Nice👍👍

[@nagarajuv8631]

Super sir

[@manojillangasooriya3590]

love it

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

[@aniketthakur2248]

Thnx🙏

[@chinmeyjain4559]

exactly what i required

[@peytono727]

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

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

[@lyndadaud85]

TQ

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

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

[@aungzawnyein3198]

Control+Shift+ down arrow function is not working on my computer. I don't know why I cannot sect all the data down the cell.

[@ZAHIDHUSSAIN-ri5kg]

Very helpul video...Many thanks Jon!

[@ExcelCampus]

Thank you Zahid! :-)

[@jonathanbrines9617]

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

[@anwanalam8845]

thanks bro!!! just splendid ! explicitly

[@shahzaibkhan1711]

i just fill 6,000 cells in A colum now i have to copy paste 50 cell to new column so i can print sheet with 50 cell in every column

[@adysyady5527]

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

[@nadianadia6099]

👍👍👍👍 Appreciate sir really helpful

[@THESKILLEVENT]

Really helpful!

[@engtap2850]

This is what I was searching for. Lovely video

[@Eunicorn046]

Omg finally found this video that helped me :)

[@mohamedlemineheyine2818]

Thank you so much, this video is very helpfull.

[@ExcelCampus]

Thank you Mohamed! :-)

[@kalm4757]

shift + arrow keys are not working inmy excel , nothing happens when i press them together

[@pandumurali.n8560]

Good clearing doubts

[@leswantht1045]

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

[@angelagarine3295]

Thank you for sharing your tips..

[@ExcelCampus]

Thank you Angela! :-)

[@matsal6680]

You're video was great,thanks!

[@kolfarm1one995]

Ctrl+Shift +Arrow is the most useful

[@peterhupka4383]

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

[@annmariejoshua698]

Thank you for your help

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

[@maayaavi]

Thank u so much 🥰

[@seethongyang4858]

Great help. Thank you.

[@xxviking1999xx]

Awesome

[@paultiefel6986]

Great video - to the point & full of content!

[@nehashahpatel1741]

Millions thanks

[@superjdillydillio9040]

Thank you Jon!

[@reaper331983]

Thank you.

[@mahdiomidali8712]

Great tutorial, thanks

[@hamidhajjafari9441]

Thanks a Million

[@live2learnplayandtravel489]

great video

[@Chhexxy]

Awesome 😁💛

[@avatarkc6108]

how to move the selected part in exel without mouse

[@usmandaud8948]

shift down in excel not working Help me

[@l_t_truth_seeker]

Thank You

[@kaveri3463]

Awesome 🔥

[@kalpanabista8016]

Thank you so much 🥺🥺

[@bestboyofindia]

thanks dear great job

[@brandonspiegel2293]

Thanks for the help!!!!

[@ExcelCampus]

Thanks Brandon! 🙂

[@pawansingh-ke4qk]

Sir ,I need pdf .

[@basicinfo6816]

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

[@joel_pm]

Ctrl + Spacebar

[@mrpips76]

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

[@RA-rh5lb]

Thanks

[@gehadmayhoub8489]

Thank you

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

[@higheringai68]

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

[@danielblank497]

Thank-you! This is really helpful.

[@lanettfielder8050]

Thank that was insightful much appreciated.