Most Useful Excel Keyboard Shortcuts

Sdílet
Vložit
  • čas přidán 8. 04. 2018
  • My entire playlist of Excel tutorials: bit.ly/tech4excel Learn what I consider to be the most useful Excel keyboard shortcuts. Some of the shortcuts included are: Ctrl+S, Ctrl+T, Ctrl+Home, Ctrl+D, and more. Download the example Excel file here: bit.ly/usefulexcelshortcuts
    ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa...
    See below links to the CDs and bands mentioned in the video:
    The Killers - Wonderful Wonderful: amzn.to/2G7AKlF
    Brandon Flowers - The Desired Effect: amzn.to/2G6gBMG
    Blaqk Audio -Material: amzn.to/2DUOfo1
    Covenant - The Blinding Dark: amzn.to/2n1J0uH
    Depeche Mode - Spirit: amzn.to/2E0BUio
    Erasure - World Be Gone: amzn.to/2G46U1t
    Future Islands - The Far Field: amzn.to/2DC7yVx
    Hurts - Desire: amzn.to/2DX6Dww
    OMD - The Punishment of Luxury: amzn.to/2DpzVmA
    The Frozen Autumn - The Fellow Traveller: amzn.to/2DXfA9f
    The Jellyrox - Bang and Whimper: amzn.to/2Drnvue
    Ulver - The Assassination of Julius Caesar: amzn.to/2DoFLEB
  • Jak na to + styl

Komentáře • 323

  • @hydrazine799
    @hydrazine799 Před 3 lety +287

    0:16 Ctrl+S = Save your file
    0:30 Ctrl+P = Print option
    0:46 Ctrl+T = Turn selected cells into table
    3:05 Ctrl+Home = Upper left cell
    3:30 Ctrl+End = Lower right cell
    3:49 Ctrl+Down Arrow = Bottom of the data
    5:08 Ctrl+Page Up = Go to previous sheet
    5:25 Ctrl+Page Down = Go to next sheet
    5:48 Ctrl+D = Autofill
    7:29 Ctrl+A = Select all cells in the table
    7:58 Ctrl+C = Copy
    8:03 Ctrl+V = Paste
    8:22 Ctrl+Space Bar = Selects entire column
    8:41 Shift+Space Bar = Selects entire row

  • @charanmg9437
    @charanmg9437 Před 5 lety +411

    Ctrl + home = top left cell
    Ctrl + end = lower right cell
    Ctrl + down button = selected column lower cell
    Ctrl + t = selected data converted to TABLE
    Ctrl + space bar = selects the entire column cells
    Ctrl + page down = switch to next sheet
    Ctrl+ page up = switch to previous sheet
    Ctrl + d = tap one the cell drag down to add that data press ctrl+d
    Ctrl + a = selects all
    Ctrl + v = paste
    Shift + space bar = selects the entire row

  • @lindseyporter8763
    @lindseyporter8763 Před 6 lety +13

    Thanks so much for this invaluable information! I'm feeling more confident about my upcoming job in which excel will frequently be used. You're absolutely correct in stressing the importance of using the keyboard vs. the mouse in terms of efficiency.

  • @fayrouzbattah1734
    @fayrouzbattah1734 Před 6 lety +5

    Looove it♡ av learned a loooot from u about excel.. I downloaded all ur excel videos before i go to a job interview and thanks to God i had the priority to have the job.. Thanks♡

  • @omarrefaye3105
    @omarrefaye3105 Před 6 lety +11

    Nice work , that was useful . I may write that on a paper 📝 and give it to anyone who works on excel . Thanks for the video and I'm waiting for the next one ❤️ .

  • @Leann222
    @Leann222 Před 5 lety +32

    I’ve recently commented on another of the excel tutorials but I must tell you...these are gold!! I just learned two things I wasn’t searching for but spent an hour on in a paid online course!
    Thank you thank you. I have vowed to master excel and your videos have made that seem less insane! 😀

  • @rezaahmed3365
    @rezaahmed3365 Před 5 lety +19

    Your videos are amazing! You are a great teacher... Thank you!

  • @breannadimaio1060
    @breannadimaio1060 Před 5 lety +6

    WHat a bright & shining light, thank you for this!!!

  • @MasterBillieChong8989
    @MasterBillieChong8989 Před 5 lety +3

    You're really giving me confidence to further enhance my knowledge on excel

  • @helenshukla1126
    @helenshukla1126 Před 5 lety +1

    Thanks so much for sharing that... the shortcut for wrapping text was a savior!

  • @lanietaray6566
    @lanietaray6566 Před 4 lety +3

    Thank you for this useful information. It helped a lot to enhance my skills in excel

  • @AbdulKarim-id4wk
    @AbdulKarim-id4wk Před 4 lety +2

    Very helpful for excel users. Many thanks for uploading such an important tutorial.

  • @adam346
    @adam346 Před 5 lety +89

    How many of you are watching this having lied about your ability to use excel and are now panicking?

  • @samuelomolo3375
    @samuelomolo3375 Před 4 lety +3

    I hav perfected my excel skills now.Thanks for making them easy to understand.

  • @chascarpenter5006
    @chascarpenter5006 Před 4 lety +1

    Very good, easy to understand & said @ a speed you could listen to all day.

  • @bknightify
    @bknightify Před 5 lety

    I learned a few that are new to me thats all the matters love learning new things to Excel - this application is never ending lol thanks for the video !

  • @el4942
    @el4942 Před 5 lety +3

    you're a great teacher. this was very helpful. thanks

  • @LizbeeHeart16
    @LizbeeHeart16 Před 5 lety +1

    Your videos are changing my life. Thanks!!

  • @lollipopper7878
    @lollipopper7878 Před 6 lety +1

    Thank you so much, you just helped me in my last minute studies!

  • @johnhogan6775
    @johnhogan6775 Před 4 lety +1

    I like the control T function. It makes the work look very professional.

  • @ninawestlake14
    @ninawestlake14 Před rokem

    You are a God send! You've boosted my confidence and you are the only teacher i ever understood in regards to computer knowledge! I love you! Bless you!💛👌🙌😘💯

  • @bukupandora
    @bukupandora Před 2 lety +1

    Thank you for the knowledge, YOUR ARE THE BOSS!, The content is really good, not a lot of others but straight to the core of the case, well explained and really nice performed

  • @nicenaiz6992
    @nicenaiz6992 Před 5 lety +4

    It's a big help. Thank you so much!

  • @kimparcia3149
    @kimparcia3149 Před 4 lety

    Thanks! It would be a great help. Gonna use it on my exams in IT Application Tools in Business

  • @selmacuellar1377
    @selmacuellar1377 Před 6 lety

    I found some very useful shortcuts, thank you for sharing!

  • @sivakumar.v.rsanjayannamal7741

    very useful tips , it saves lot of time and easy to work in spread sheets

  • @williamconway1080
    @williamconway1080 Před 5 lety

    I am very pleased with this very clear video. Thank you

  • @kiprotichcheruiyot8679

    i benefited from this..and keep on bringing us more knowledge like this..i enjoy it

  • @pranitraj7701
    @pranitraj7701 Před 3 lety

    Awesome Video. Just Liked it. The commands are really very cool the way it was explained. Keep up the great work.

  • @MissMiriamka
    @MissMiriamka Před 5 lety

    Very useful tutorial for memorising the shortcuts.

  • @ashleym9067
    @ashleym9067 Před 5 lety +4

    Loved! Thank you so much. I appreciate you taking your time with explaining the steps, and revisiting previous material as a refresher. Your videos are my fav!!

  • @trueleyes
    @trueleyes Před 2 lety +5

    NOW YOU'RE TALKING, These I can use. I never knew where to find these KEYSTOKES and so I don't use any keystrokes but now I will. THNX PROFESSOR.

  • @georgeyoung6639
    @georgeyoung6639 Před 5 lety +1

    This is going to be so helpful, thanks.

  • @lynnhandy5638
    @lynnhandy5638 Před 4 lety

    Fabulous, just what I needed for my new job!!

  • @philiplbrown
    @philiplbrown Před rokem +2

    super informative video. Clear, concise and very well presented.

  • @minhae970524
    @minhae970524 Před 2 lety +1

    Thank you for this amazing tutorial!

  • @syljihomom
    @syljihomom Před 5 lety +1

    Best excel tutorial!! Your explanation is very clear, to the point and very helpful. Thank you.

  • @jadad1010
    @jadad1010 Před 2 lety +1

    Thank you. These basics are helpful for beginners

  • @minervagaines995
    @minervagaines995 Před 5 lety

    Your videos have been very helpful!

  • @hellentrinnahk
    @hellentrinnahk Před rokem

    Your content have helped learn MS Excel at a high speed, Big up!

  • @CHBeck0514
    @CHBeck0514 Před 3 lety

    Wow, thanks man! I learn a new trick in EVERY video!

  • @melfromtoronto8746
    @melfromtoronto8746 Před 4 lety +6

    WOW. I'll be practicing these shortcut keys at work from now on. Thanks again! (y)

  • @donfillenworth1721
    @donfillenworth1721 Před 5 lety

    Great information. Thanks for sharing

  • @percivalsimon6202
    @percivalsimon6202 Před 4 lety

    Thank you very much! Keep up the good work!

  • @patricebennett1100
    @patricebennett1100 Před rokem

    That was so helpful. Love your content 🌸

  • @catworld9697
    @catworld9697 Před rokem

    so handy I am heading back to the work force and these videos are fantastic thank you

  • @laman8914
    @laman8914 Před 4 měsíci

    Short cuts are fun to work with. Makes work easier. Thanks

  • @teridelcollo6221
    @teridelcollo6221 Před rokem

    I just wanted to say thank you for taking the time out and explaining things clearly. Where can I get a PDF file of your Excel shortcuts.

  • @NasirKhan-vh9bg
    @NasirKhan-vh9bg Před rokem

    Highly appreciate. Nice way of explaining and elaborating 👍👍👍

  • @graemed-g522
    @graemed-g522 Před 4 lety +3

    Control T - that could have save me so much time, thank you.

  • @john-di1mz
    @john-di1mz Před 5 lety

    thanku...excellent presentation sir...!!!

  • @vosbeats9096
    @vosbeats9096 Před 5 lety

    Awesome, thank you!

  • @botdavid323
    @botdavid323 Před 3 lety

    I'm learning Excel right now. Thanks for the info!

  • @audreyreyes3881
    @audreyreyes3881 Před 4 lety

    I've been working in Excel for over three years now, and I am unreasonably excited to hear about Ctrl + Space and Shift + Space, even though highlighting the full row typically works for me.

  • @deniseanddavemccullough366

    Very helpful. Thank you!

  • @dudaidudai1138
    @dudaidudai1138 Před 4 lety

    thank you for sharing this video ,it's really helpful ,,God bless !

  • @pasindunimshan3708
    @pasindunimshan3708 Před 4 lety

    I really love your videos, they are really beneficial.... Kudos to you :)

  • @juliegoldman5500
    @juliegoldman5500 Před 5 lety +1

    New to Excel great short cuts

  • @guyshootseverything
    @guyshootseverything Před 6 lety +14

    Ctrl + T saves so much time. Thanks

  • @yzzachtin6263
    @yzzachtin6263 Před 2 lety +1

    thank you so much for this. Very useful

  • @leeyuntoot1352
    @leeyuntoot1352 Před 5 lety

    So useful, thank you ^^

  • @anelson6137
    @anelson6137 Před 3 lety

    This was much needed!!!!👍🏼

  • @teresewilson5090
    @teresewilson5090 Před 5 lety

    You are an excellent teacher

  • @snaik7372
    @snaik7372 Před rokem

    You are so helpful i found Excel very interesting after watching your video keep the good work ❤

  • @presentationdue
    @presentationdue Před 4 lety

    Bro, you are saving my life *daily.*

  • @rodneymaconline
    @rodneymaconline Před 4 lety

    really helpful, thank you so very much

  • @AngelaSchansAuthor
    @AngelaSchansAuthor Před 6 lety +1

    These are amazing! Thank you so so so much! You are GREAT at this!

  • @abhilashasimha
    @abhilashasimha Před rokem

    You taught very well. Your teaching is very nice.

  • @S0phisticatedZ0mbie
    @S0phisticatedZ0mbie Před 5 lety

    Appreciate you for this video buddy

  • @saiednajafian9814
    @saiednajafian9814 Před 5 lety

    It was very helpful thanks.

  • @starbright1458
    @starbright1458 Před 2 lety +1

    I have learned so much thank u 🙏

  • @subhrojyotisinharoy6981

    I learned a lot from here thankyou ❤️

  • @beverlyfrederick5362
    @beverlyfrederick5362 Před 4 lety

    Awesome Tips ~ Thanks Much !

  • @getfanmedia
    @getfanmedia Před rokem

    I'm a follower of your videos, they are all interesting. thanks for sharing your knowledge.

  • @timothykwemoi9036
    @timothykwemoi9036 Před rokem

    Incredibly helpful,thank you

  • @migueles4834
    @migueles4834 Před 2 lety +5

    Thanks for your very useful and pedagogical videos. I've learned quite a lot of stuff through them. One question: for me Ctrl + Space doesn't select the column, as you claim, but the entire table area. What could be the reason for that? Also, is there a key or combination of keys to cancel a specific selection? If I do Shift + Space it selects the row where I'm at, but is there a one-click way to de-select the row instead of clicking outside the selection area? I've tried repeating the same shortcut (Shift + Space) and Escape key but nothing works other than clicking outside the selection area. Thanks in advance and keep up your great work.

  • @Practical-Theoretical
    @Practical-Theoretical Před 2 lety

    Very helpful, thanks mate

  • @las0aguas
    @las0aguas Před 3 lety

    Thank you for videos they help me a lot in my job

  • @simpleexcelexamples9619
    @simpleexcelexamples9619 Před 2 lety +2

    Very useful to work more efficiently in Excel! Thank you for this great video 😊

  • @nischalnepal9102
    @nischalnepal9102 Před 3 lety

    thanks for information and your support

  • @venukrishna8453
    @venukrishna8453 Před 2 lety +1

    Amazing video learnt a lot

  • @manjukodwaney373
    @manjukodwaney373 Před 3 lety

    Very useful, thank you sir👍

  • @OtodidakwithKangAdit
    @OtodidakwithKangAdit Před 5 lety

    Thanks man, it help a lot

  • @amega351
    @amega351 Před 5 lety

    So great love your video

  • @jayshree3592
    @jayshree3592 Před 2 lety +1

    Amazing excel tutorial thanks alot

  • @yasamanhr7104
    @yasamanhr7104 Před 5 lety

    thanks for your effort

  • @samsonjsml1950
    @samsonjsml1950 Před 4 lety

    It was really helpful ...please keep posting more

  • @s.karlongolocooper4953

    Thanks for your this lesson.

  • @adeelulhaque3624
    @adeelulhaque3624 Před 5 lety +2

    All I already knew but it was very useful for me :)

  • @victorgoomes6239
    @victorgoomes6239 Před 5 lety

    Good video, thanks

  • @ClubHondumexMedia
    @ClubHondumexMedia Před 4 lety

    Thank you for your videos 👍

  • @abdidekmuhumed4510
    @abdidekmuhumed4510 Před 4 lety

    Very useful thank you

  • @NadeemKhan-lt7no
    @NadeemKhan-lt7no Před 5 lety

    Very useful !

  • @Therealestrunnerluda
    @Therealestrunnerluda Před 5 lety

    To the point thank you

  • @bethjardiolin2838
    @bethjardiolin2838 Před 3 lety

    Its amazing tutorial.. Hope to see more shortcut in excel videos.. First time here

  • @lornabolima2843
    @lornabolima2843 Před 3 lety

    thank you so much I learned a lot

  • @ajithrld2972
    @ajithrld2972 Před 5 lety

    whoaa so useful, thank you so much........

  • @esiridelekpe8385
    @esiridelekpe8385 Před 4 lety

    Thank you so much😁👍🏾

  • @rachelagbuya9606
    @rachelagbuya9606 Před 2 lety

    Thank you so much for this

  • @ntebeleagreement3459
    @ntebeleagreement3459 Před 5 lety +1

    i enjoyed the lessons, that was wonderful, thank u