Most Useful Excel Keyboard Shortcuts

Поділитися
Вставка
  • Опубліковано 12 січ 2025

КОМЕНТАРІ • 321

  • @hydrazine799
    @hydrazine799 3 роки тому +303

    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 5 років тому +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

  • @trueleyes
    @trueleyes 3 роки тому +6

    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 років тому +33

    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 6 років тому +96

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

  • @hellentrinnahk
    @hellentrinnahk 2 роки тому

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

  • @laman8914
    @laman8914 10 місяців тому

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

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

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

  • @philiplbrown
    @philiplbrown 2 роки тому +2

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

  • @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♡

  • @ninawestlake14
    @ninawestlake14 2 роки тому

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

  • @jadad1010
    @jadad1010 2 роки тому +1

    Thank you. These basics are helpful for beginners

  • @breannadimaio1060
    @breannadimaio1060 6 років тому +6

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

  • @MasterBillieChong8989
    @MasterBillieChong8989 5 років тому +3

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

  • @sivakumar.v.rsanjayannamal7741
    @sivakumar.v.rsanjayannamal7741 4 роки тому +2

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

  • @KishanKumar-tv8yw
    @KishanKumar-tv8yw 2 місяці тому

    Essential Excel Shortcuts:
    0:16 Ctrl + S: Save your file. Handy to avoid losing work!
    0:30 Ctrl + P: Opens the print dialog box. Quick access to printing options.
    0:46 Ctrl + T: Converts selected cells into a table. Useful for organizing data.
    3:05 Ctrl + Home: Moves to the upper-left cell (A1) of your worksheet.
    3:30 Ctrl + End: Moves to the last cell with data on your worksheet.
    3:49 Ctrl + Down Arrow: Jumps to the bottom of the current data range.
    5:08 Ctrl + Page Up: Switches to the previous worksheet tab.
    5:25 Ctrl + Page Down: Switches to the next worksheet tab.
    5:48 Ctrl + D: Autofill cells with the content above.
    7:29 Ctrl + A: Selects all cells in the worksheet or table.
    7:58 Ctrl + C: Copies the selected cells.
    8:03 Ctrl + V: Pastes the copied content.
    8:22 Ctrl + Space Bar: Selects the entire column.
    8:41 Shift + Space Bar: Selects the entire row.
    These shortcuts will definitely speed up your workflow and make navigating Excel a breeze. Want to learn more about any specific feature or shortcut?

  • @NasirKhan-vh9bg
    @NasirKhan-vh9bg Рік тому

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

  • @AbdulKarim-id4wk
    @AbdulKarim-id4wk 5 років тому +2

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

  • @abhilashasimha
    @abhilashasimha 2 роки тому

    You taught very well. Your teaching is very nice.

  • @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 ❤️ .

  • @lanietaray6566
    @lanietaray6566 4 роки тому +3

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

  • @chascarpenter5006
    @chascarpenter5006 4 роки тому +1

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

  • @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 5 років тому +3

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

  • @lindaadalla2956
    @lindaadalla2956 3 місяці тому

    This is very helpful and interesting ❤thank you so much!!!

  • @getfanmedia
    @getfanmedia 2 роки тому

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

  • @Neo-madnes
    @Neo-madnes Рік тому

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

  • @haqueheraclia186
    @haqueheraclia186 2 роки тому +1

    Wow Thanks this wonderful Video

  • @mariasarri1517
    @mariasarri1517 6 років тому +15

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

  • @jayshree3592
    @jayshree3592 2 роки тому +1

    Amazing excel tutorial thanks alot

  • @timothykwemoi9036
    @timothykwemoi9036 Рік тому

    Incredibly helpful,thank you

  • @snaik7372
    @snaik7372 Рік тому

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

  • @venukrishna8453
    @venukrishna8453 2 роки тому +1

    Amazing video learnt a lot

  • @starbright1458
    @starbright1458 3 роки тому +1

    I have learned so much thank u 🙏

  • @LizbeeHeart16
    @LizbeeHeart16 6 років тому +1

    Your videos are changing my life. Thanks!!

  • @coastersandcars63
    @coastersandcars63 4 роки тому

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

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

  • @melfromtoronto8746
    @melfromtoronto8746 4 роки тому +6

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

  • @patricebennett1100
    @patricebennett1100 Рік тому

    That was so helpful. Love your content 🌸

  • @el4942
    @el4942 6 років тому +3

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

  • @minhae970524
    @minhae970524 3 роки тому +1

    Thank you for this amazing tutorial!

  • @pranitraj7701
    @pranitraj7701 4 роки тому

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

  • @nicenaiz6992
    @nicenaiz6992 5 років тому +4

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

  • @nischalnepal9102
    @nischalnepal9102 3 роки тому

    thanks for information and your support

  • @botdavid323
    @botdavid323 4 роки тому

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

  • @bknightify
    @bknightify 6 років тому

    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 !

  • @sourovajmain2048
    @sourovajmain2048 4 роки тому

    Ctrl + D is new for me. Thanks

  • @sujanikoralagedon1097
    @sujanikoralagedon1097 3 роки тому

    Nice work 😃😜

  • @lynnhandy5638
    @lynnhandy5638 4 роки тому

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

  • @anelson6137
    @anelson6137 3 роки тому

    This was much needed!!!!👍🏼

  • @las0aguas
    @las0aguas 4 роки тому

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

  • @HOWTOEngineering
    @HOWTOEngineering 2 роки тому +1

    VERY USEFUL

  • @Kolian1274
    @Kolian1274 3 роки тому +1

    Hello
    I enjoy watching your channel can you tell me how can I create a random number between 20 to 39 to create five digit random number
    In Excel

  • @KartiniSihombingKaSihT0P
    @KartiniSihombingKaSihT0P 2 роки тому

    Very informative video
    Thank you for sharing

  • @mn6780
    @mn6780 3 роки тому

    Thanks Just what I was looking for

  • @jamesmyrthong6112
    @jamesmyrthong6112 3 роки тому

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

  • @SamsonJSMLthokchom
    @SamsonJSMLthokchom 4 роки тому

    It was really helpful ...please keep posting more

  • @Practical-Theoretical
    @Practical-Theoretical 2 роки тому

    Very helpful, thanks mate

  • @lollipopper7878
    @lollipopper7878 6 років тому +1

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

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

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

  • @juliegoldman5500
    @juliegoldman5500 6 років тому +1

    New to Excel great short cuts

  • @bethjardiolin2838
    @bethjardiolin2838 4 роки тому

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

  • @gopalakrishnan5895
    @gopalakrishnan5895 2 роки тому +1

    This lesson is 👌🌲

  • @ClubHondumexMedia
    @ClubHondumexMedia 4 роки тому

    Thank you for your videos 👍

  • @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?)

  • @manjukodwaney373
    @manjukodwaney373 4 роки тому

    Very useful, thank you sir👍

  • @subhrojyotisinharoy6981
    @subhrojyotisinharoy6981 3 роки тому

    I learned a lot from here thankyou ❤️

  • @deniseanddavemccullough366
    @deniseanddavemccullough366 4 роки тому

    Very helpful. Thank you!

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

  • @georgeyoung6639
    @georgeyoung6639 6 років тому +1

    This is going to be so helpful, thanks.

  • @minervagaines995
    @minervagaines995 5 років тому

    Your videos have been very helpful!

  • @rachelagbuya9606
    @rachelagbuya9606 2 роки тому

    Thank you so much for this

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

  • @zanpotter3014
    @zanpotter3014 3 роки тому

    Thank you this sir. I am going to the exam about excel next week.

  • @kiprotichcheruiyot8679
    @kiprotichcheruiyot8679 6 років тому

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

  • @selmacuellar1377
    @selmacuellar1377 6 років тому

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

  • @simpleexcelexamples9619
    @simpleexcelexamples9619 3 роки тому +2

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

  • @audreyreyes3881
    @audreyreyes3881 5 років тому

    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.

  • @williamconway1080
    @williamconway1080 6 років тому

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

  • @douglasansah435
    @douglasansah435 4 роки тому

    Thank for wonderful videos. Do you no any game that contains excel for practice?

  • @percivalsimon6202
    @percivalsimon6202 5 років тому

    Thank you very much! Keep up the good work!

  • @presentationdue
    @presentationdue 5 років тому

    Bro, you are saving my life *daily.*

  • @beverlyfrederick5362
    @beverlyfrederick5362 4 роки тому

    Awesome Tips ~ Thanks Much !

  • @NicoleC510
    @NicoleC510 3 роки тому

    best teacher!

  • @MissMiriamka
    @MissMiriamka 6 років тому

    Very useful tutorial for memorising the shortcuts.

  • @sanelasarac7425
    @sanelasarac7425 2 роки тому

    Thank you!

  • @s.karlongolocooper4953
    @s.karlongolocooper4953 4 роки тому

    Thanks for your this lesson.

  • @bbchetri5313
    @bbchetri5313 4 роки тому

    Really very much helpful

  • @adeelulhaque3624
    @adeelulhaque3624 6 років тому +2

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

  • @balnarayana
    @balnarayana 4 роки тому

    Sir very good explanation with congratulations and thanks

  • @kirangurung3108
    @kirangurung3108 Рік тому

    Thanks 🙏

  • @pasindunimshan3708
    @pasindunimshan3708 5 років тому

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

  • @esiridelekpe8385
    @esiridelekpe8385 4 роки тому

    Thank you so much😁👍🏾

  • @bestlearnings4265
    @bestlearnings4265 Рік тому

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

  • @dddog9024
    @dddog9024 2 роки тому

    Useful, Thanks

  • @trmusanyusaofficial876
    @trmusanyusaofficial876 2 роки тому

    Awesome 👌