Most Useful Excel Keyboard Shortcuts

Поделиться
HTML-код
  • Опубликовано: 20 сен 2024
  • 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/usefulex...
    Join this channel to get access to perks:
    / @techteachersandstudents
    ***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

Комментарии • 322

  • @hydrazine799
    @hydrazine799 3 года назад +292

    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

    • @ruthihejirika9467
      @ruthihejirika9467 2 года назад +1

      What about for Mac?

    • @mieczyslawm7093
      @mieczyslawm7093 2 года назад

      How about fuq you. Your Control + T is on my keyboard Control + L.

    • @denised.5300
      @denised.5300 2 года назад

      Thank you professor I'm trying to get a new job

    • @yvng4697
      @yvng4697 Год назад

      @@denised.5300 did u got the new job?

    • @mariatovar1657
      @mariatovar1657 Год назад

      3edxxxxxxxxxxxxxxxx

  • @charanmg9437
    @charanmg9437 5 лет назад +409

    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

  • @trueleyes
    @trueleyes 2 года назад +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.

  • @Leann222
    @Leann222 6 лет назад +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! 😀

  • @adam346
    @adam346 5 лет назад +92

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

  • @philiplbrown
    @philiplbrown 2 года назад +2

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

  • @haqueheraclia186
    @haqueheraclia186 2 года назад +1

    Wow Thanks this wonderful Video

  • @rezaahmed3365
    @rezaahmed3365 5 лет назад +19

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

  • @laman8914
    @laman8914 6 месяцев назад

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

  • @breannadimaio1060
    @breannadimaio1060 6 лет назад +6

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

  • @jadad1010
    @jadad1010 2 года назад +1

    Thank you. These basics are helpful for beginners

  • @yzzachtin6263
    @yzzachtin6263 2 года назад +1

    thank you so much for this. Very useful

  • @jayshree3592
    @jayshree3592 2 года назад +1

    Amazing excel tutorial thanks alot

  • @ninawestlake14
    @ninawestlake14 Год назад

    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!💛👌🙌😘💯

  • @HOWTOEngineering
    @HOWTOEngineering 2 года назад +1

    VERY USEFUL

  • @venukrishna8453
    @venukrishna8453 2 года назад +1

    Amazing video learnt a lot

  • @sivakumar.v.rsanjayannamal7741
    @sivakumar.v.rsanjayannamal7741 4 года назад +2

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

  • @chascarpenter5006
    @chascarpenter5006 4 года назад +1

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

  • @hellentrinnahk
    @hellentrinnahk Год назад

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

  • @getfanmedia
    @getfanmedia Год назад

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

  • @AbdulKarim-id4wk
    @AbdulKarim-id4wk 5 лет назад +2

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

  • @lindseyporter8763
    @lindseyporter8763 6 лет назад +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.

  • @NasirKhan-vh9bg
    @NasirKhan-vh9bg Год назад

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

  • @abhilashasimha
    @abhilashasimha Год назад

    You taught very well. Your teaching is very nice.

  • @lanietaray6566
    @lanietaray6566 4 года назад +3

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

  • @MasterBillieChong8989
    @MasterBillieChong8989 5 лет назад +3

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

  • @fayrouzbattah1734
    @fayrouzbattah1734 6 лет назад +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♡

  • @starbright1458
    @starbright1458 3 года назад +1

    I have learned so much thank u 🙏

  • @guyshootseverything
    @guyshootseverything 6 лет назад +14

    Ctrl + T saves so much time. Thanks

  • @samuelomolo3375
    @samuelomolo3375 4 года назад +3

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

  • @omarrefaye3105
    @omarrefaye3105 6 лет назад +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 ❤️ .

  • @johnhogan6775
    @johnhogan6775 4 года назад +1

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

  • @helenshukla1126
    @helenshukla1126 5 лет назад +1

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

  • @graemed-g522
    @graemed-g522 4 года назад +3

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

  • @LizbeeHeart16
    @LizbeeHeart16 6 лет назад +1

    Your videos are changing my life. Thanks!!

  • @timothykwemoi9036
    @timothykwemoi9036 Год назад

    Incredibly helpful,thank you

  • @nicenaiz6992
    @nicenaiz6992 5 лет назад +4

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

  • @snaik7372
    @snaik7372 Год назад

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

  • @el4942
    @el4942 6 лет назад +3

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

  • @nischalnepal9102
    @nischalnepal9102 3 года назад

    thanks for information and your support

  • @syljihomom
    @syljihomom 5 лет назад +1

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

    • @wasimprince4353
      @wasimprince4353 5 лет назад

      Hi you need to learn excel more i will teach you

  • @minhae970524
    @minhae970524 3 года назад +1

    Thank you for this amazing tutorial!

  • @catworld9697
    @catworld9697 Год назад

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

  • @CHBeck0514
    @CHBeck0514 4 года назад

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

  • @patricebennett1100
    @patricebennett1100 Год назад

    That was so helpful. Love your content 🌸

  • @raveeshroy
    @raveeshroy Год назад +4

    1:03 TO TURN THE DATA INTO A TABLE PRESS CONTROL+T 2:57 GO TO THE TOP LEFT CORNER OF EXCEL SHEET 3:25 GO TO THE BOTTOM RIGHT CORNER OF YOUR EXCEL SHEET 3:47 CONTROL+DOWN ARROW TAKES YOU TO THE BOTTOM OF DATA IN A COLUMN 4:44 IF YOU WANT TO SELECT PREVIOUS SHEET PRESS CONTROL+PAGE UP KEY 5:21 IF YOU WANT TO MOVE TO THE NEXT SHEET PRESS CONTROL+PAGE DOWN KEY 8:21 CONTROL+SPACE FOR SELECTIONG ENTIRE COLUMN 8:39 SHIFT +SPACE SELECTS THE ENTIRE ROW

  • @bukupandora
    @bukupandora 3 года назад +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

  • @KartiniSihombingKaSihT0P
    @KartiniSihombingKaSihT0P 2 года назад

    Very informative video
    Thank you for sharing

  • @sourovajmain2048
    @sourovajmain2048 3 года назад

    Ctrl + D is new for me. Thanks

  • @melfromtoronto8746
    @melfromtoronto8746 4 года назад +6

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

  • @pranitraj7701
    @pranitraj7701 3 года назад

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

  • @paulvanobberghen
    @paulvanobberghen 4 года назад

    CTRL + R will do the same as CTRL + D but will copy to the right if you've selected some cells on the same row. (R = Right and D = Down?)

  • @las0aguas
    @las0aguas 4 года назад

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

  • @gopalakrishnan5895
    @gopalakrishnan5895 2 года назад +1

    This lesson is 👌🌲

  • @rachelagbuya9606
    @rachelagbuya9606 2 года назад

    Thank you so much for this

  • @mn6780
    @mn6780 3 года назад

    Thanks Just what I was looking for

  • @anelson6137
    @anelson6137 3 года назад

    This was much needed!!!!👍🏼

  • @lynnhandy5638
    @lynnhandy5638 4 года назад

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

  • @botdavid323
    @botdavid323 3 года назад

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

  • @samsonjsml1950
    @samsonjsml1950 4 года назад

    It was really helpful ...please keep posting more

  • @migueles4834
    @migueles4834 3 года назад +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.

  • @juliegoldman5500
    @juliegoldman5500 6 лет назад +1

    New to Excel great short cuts

  • @sanelasarac7425
    @sanelasarac7425 2 года назад

    Thank you!

  • @Practical-Theoretical
    @Practical-Theoretical 2 года назад

    Very helpful, thanks mate

  • @nengtech6914
    @nengtech6914 4 года назад

    thanks for your sharing

  • @ClubHondumexMedia
    @ClubHondumexMedia 4 года назад

    Thank you for your videos 👍

  • @simpleexcelexamples9619
    @simpleexcelexamples9619 2 года назад +2

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

  • @deniseanddavemccullough366
    @deniseanddavemccullough366 4 года назад

    Very helpful. Thank you!

  • @teridelcollo6221
    @teridelcollo6221 2 года назад

    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.

  • @jamesmyrthong6112
    @jamesmyrthong6112 3 года назад

    Thank You Very much 🙏🙏🙏🇮🇳🇮🇳🇮🇳

  • @lollipopper7878
    @lollipopper7878 6 лет назад +1

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

  • @sgn01149
    @sgn01149 2 года назад +1

    excellent informaiton

  • @williamconway1080
    @williamconway1080 5 лет назад

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

  • @s.karlongolocooper4953
    @s.karlongolocooper4953 3 года назад

    Thanks for your this lesson.

  • @georgeyoung6639
    @georgeyoung6639 6 лет назад +1

    This is going to be so helpful, thanks.

  • @enochjnr6341
    @enochjnr6341 Год назад

    Thank you

  • @solomonkhumana338
    @solomonkhumana338 4 года назад

    great teacher

  • @dddog9024
    @dddog9024 2 года назад

    Useful, Thanks

  • @AngelaSchansAuthor
    @AngelaSchansAuthor 6 лет назад +1

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

  • @bknightify
    @bknightify 5 лет назад

    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 !

  • @kirangurung3108
    @kirangurung3108 Год назад

    Thanks 🙏

  • @ashleym9067
    @ashleym9067 5 лет назад +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!!

  • @bbchetri5313
    @bbchetri5313 4 года назад

    Really very much helpful

  • @minervagaines995
    @minervagaines995 5 лет назад

    Your videos have been very helpful!

  • @balnarayana
    @balnarayana 3 года назад

    Sir very good explanation with congratulations and thanks

  • @caitanbraganca1943
    @caitanbraganca1943 4 года назад

    Nice video
    Thank you

  • @bethjardiolin2838
    @bethjardiolin2838 4 года назад

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

  • @manjukodwaney373
    @manjukodwaney373 3 года назад

    Very useful, thank you sir👍

  • @kiprotichcheruiyot8679
    @kiprotichcheruiyot8679 5 лет назад

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

  • @adeelulhaque3624
    @adeelulhaque3624 5 лет назад +2

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

  • @evelingarce9117
    @evelingarce9117 Год назад

    when I put control´+ s, i highlight my data and control+f4 is to save

  • @selmacuellar1377
    @selmacuellar1377 6 лет назад

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

  • @MissMiriamka
    @MissMiriamka 6 лет назад

    Very useful tutorial for memorising the shortcuts.

  • @bestlearnings4265
    @bestlearnings4265 11 месяцев назад

    "Excel is an ocean of undiscovered possibilities, where every click and formula unveils solutions waiting to be found."

  • @percivalsimon6202
    @percivalsimon6202 4 года назад

    Thank you very much! Keep up the good work!

  • @subhrojyotisinharoy6981
    @subhrojyotisinharoy6981 3 года назад

    I learned a lot from here thankyou ❤️

  • @beverlyfrederick5362
    @beverlyfrederick5362 4 года назад

    Awesome Tips ~ Thanks Much !

  • @pasindunimshan3708
    @pasindunimshan3708 4 года назад

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

  • @john-di1mz
    @john-di1mz 5 лет назад

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

  • @abdidekmuhumed4510
    @abdidekmuhumed4510 5 лет назад

    Very useful thank you