Excel Shortcut Keys | Full Guide

Поделиться
HTML-код
  • Опубликовано: 21 ноя 2024
  • НаукаНаука

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

  • @KevinStratvert
    @KevinStratvert  4 года назад +16

    🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
    ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ruclips.net/p/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

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

      I want to work as a financial assistance but I have no job experience. Can you help

  • @mohdabdulmateen5159
    @mohdabdulmateen5159 2 года назад +22

    Good Evening Sir, I"m from india & i've been searching a teacher like u who gonna explain everything in detail as u did in this video, because i was at zero in MS Excel and unable to find correct path to grow but i found u here, i truly admire u & have a huge respect for your time. Thank u from bottom of my heart. Please keep making new knowledgeable videos on MS Excel. i'v also shared your videos to my loved ones & family.🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰

  • @OlufojudeGbenga
    @OlufojudeGbenga 11 часов назад

    I wish I could like this video a million times it's so simple easy when you teach❤

  • @AndreaGibson-fc7pt
    @AndreaGibson-fc7pt 2 года назад +9

    Thank you! Just watched a number of your videos from shortcuts to Pivot Tables, Concat and Macros. Your videos are so helpful and much appreciated.

  • @gowaymike9509
    @gowaymike9509 3 года назад +89

    There are short keys worth mentioning that not covered in this video. After selecting row(s) or column(s) by using the shortcut key as illustrated in this video, press Ctrl + minus sign to delete, Ctrl + Shift + plus sign to insert

    • @jillturner4053
      @jillturner4053 3 года назад +6

      omg this is amazing thank you.

    • @joyabsalon9216
      @joyabsalon9216 2 года назад +4

      True. This is indeed worth mentioning😊

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

      Yes. I used a lot of plus and minus sign.

    • @itsnotif.itswhen
      @itsnotif.itswhen Год назад

      Yes, the Ctrl + Shift + plus sign to insert is huge in my daily workflow when I adjust general ledger items for bank reconciliation.

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

      thank you!

  • @ciaran110505
    @ciaran110505 2 года назад +7

    Brilliant Kevin you have restored my belief in Excel as i have not had to use it for a while so watching your Videos has been fantastic keep them coming.

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

    Bro, Excel is my weakness since I came to the United States. I didn’t Accounting from overseas but never did anything about Excel. I really like the Excel shortcuts. And I will definitely prefer to work with you. Hope we can be in touch and get more knowledge on Excel. I really appreciate if you can be my teacher. Thank you .

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

    The alt shortcut to navigate the ribbon is great!

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

      Alt h h to highlight without the mouse saves me time!

  • @dariusanderton3760
    @dariusanderton3760 3 года назад +5

    a story from a very long time ago I first learned spreadsheets before computer mice were common, and many things were in DOS (before WIndows). Keyboard shortcuts were the only way to do things, along with Function keys. Then when Windows and computer mice came along it seemed like all the young people were using the mouse and right clicking or left clicking on things, and it was just the old people who used the keyboard shortcuts. So I kind of forgot many of the keyboard shortcuts for a few years, but then other people were all saying the shortcuts were faster so I took the effort to learn them again.

  • @joelweiss7013
    @joelweiss7013 4 года назад +7

    Thanks Kevin. I learned many new ones. I will be watching & studying more of your videos to learn, adapt, and apply my new knowledge.

  • @ianpatrick23
    @ianpatrick23 Год назад +2

    This was super helpful getting me up to speed on Excel. Thank you!

  • @MyRockMyFortress
    @MyRockMyFortress 24 дня назад

    Thank you for this wonderful tutorial.

  • @arthurletim1248
    @arthurletim1248 3 года назад +2

    this is very helpful for us visually impaired community. shortcut keys is the best way to navigate excel. keep it up! thanks!

  • @MrDariusAtl
    @MrDariusAtl 9 месяцев назад

    Kevin always come with fire content. 🙌🏾🔥

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

    You are such a perfect guy who should be doing tv apps

  • @6989yogesh
    @6989yogesh 2 года назад +6

    9:55 - T stands for table and L for list box. Tables were referred to list box until 2003 versions.

    • @KevinStratvert
      @KevinStratvert  2 года назад +4

      Ah, that makes sense! Thanks for sharing!

  • @OlufojudeGbenga
    @OlufojudeGbenga 11 часов назад +1

    Am literally studying this because of my assignment 😂😂😂

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

    Thank you. The alt+enter, I wanted that. Very helpful.❤

  • @MyRockMyFortress
    @MyRockMyFortress 25 дней назад

    I love Ctrl+Shift+! to apply number format

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

    you are the best!! Learning alot from you 😌

  • @dyeninalibut3025
    @dyeninalibut3025 Год назад +1

    Thanks again, Kevin! You make learning easy and straightforward! Glued to your videos!

  • @vaibhavsumit7917
    @vaibhavsumit7917 3 года назад +2

    Hi Kevin, nice job learnt 5-6 new shortcut enjoyed your video keep posting such videos. thanks

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

    incredible. So easy to learn. Thanks Kevin

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

    enjoyed with the shortcuts.

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

    Great resource. You may want to double check your Ctrl+Shift+Home and Ctrl+Shift+End The printed instructions seem to not follow the directions.

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

    Thank you so much, Kevin - this was awesome :)

  • @wcarlosw
    @wcarlosw 4 года назад +8

    Can someone do a compilation of his intros? They are the cutest things ever.

  • @m.mohtashim2000
    @m.mohtashim2000 4 года назад +13

    Thank you so much for sharing this sir. I'm so grateful to you for teaching me so much in so little time through your videos. Lots of love and tons of support from your little brother here. ♥️😊

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

    Very helpful! Thank you.

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

    Thank you. It's very much helpful

  • @meghanb4541
    @meghanb4541 3 года назад +9

    This is excellent. A lot of clear and concise information in a short amount of time. Thank you!

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

    Excellent video.. Valuable content👍

  • @nathanielbalmes6597
    @nathanielbalmes6597 9 месяцев назад

    Thanks, Kevin! This is a big help. :)

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

    Thank you kevin ilearned so many iwill be contenue watching & studying more of your vedios

  • @reddlief
    @reddlief 7 месяцев назад

    Seems I need to use the keyboard row of numbers and not my keypad numbers. Only works with the top row. Great video. Can you copy a formula down a column using a short cut?

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

    Merci pour exister! and thanks for the amazing & insightful content 😍

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

    Superb learning Excel shortcuts

  • @zishangamer6392
    @zishangamer6392 Месяц назад

    Yes I got it very helpful video thanks ❤

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

    I have learned a lot from your video,
    thanks a bunch

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

    a quiz with these shortcut keys would be perfect for a person preparing for exam.

  • @ushernleya3626
    @ushernleya3626 5 месяцев назад

    thanks Kevin good stuff

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

    Wow... Your eye color makes it so obvious of how much time you have spent learning this software...

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

    Thank you for your information

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

    Thank you for such a nice video 🎉🎉

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

    Thank you so much. I learned a lot today:)

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

    This was really helpful bro thanks

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

    Thanks! Everything except 2 I didn't know

  • @the.min9yu_k.fangirl
    @the.min9yu_k.fangirl Год назад

    thank you soooooo much for this!

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

    Oh my God ! ! That's so much help in one video. Thanks a lot

  • @Gcharms
    @Gcharms Месяц назад

    Great video. Can someone tell me how do I remove the shortcuts to start with key "/". Thank you

  • @buddhinihini6588
    @buddhinihini6588 4 года назад +2

    Thank you so much

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

    Thank you teacher!!!!!

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

    Very nice class keep it up
    Your understanding way is very unique 👌

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

    Thank you Sir Kevin

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

    Thank u soo much this is very helpful

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

    it's really educative.

  • @JumpRopeVeteran
    @JumpRopeVeteran 4 года назад +5

    Thanks a lot. There were several I didn't know.

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

    great job

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

    thanks for your kind efforts.

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

    Thank you for sharing the shortcut link !!! Do you have follow along videos???

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

    thank you so much sir

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

    You are perfect 👍🏻

  • @nataliadavila3827
    @nataliadavila3827 3 года назад +6

    This was extremely helpful! Thank you for making this video. 💜

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

    Thank You you're awesome!

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

    I love this, you have made my job so much easier. I do have a question. I was (Making a correction)working on the middle of my spreadsheet. I had to go to the end to add more info. How do I get back to that spot I was working on without having to scroll up. Is there a shortcut to go back to the last spot I was making a correction on?

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

    Great job..!

  • @sunpasirithxssunpasiri4759
    @sunpasirithxssunpasiri4759 Год назад +1

    Colud you please teach the tip that "select all colums with blanks row"?

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

    Interesting. Thanks.

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

    To delete a column:
    Ctrl+Space
    Ctrl+-
    To delete a row:
    Ctrl+Shift
    Ctrl+-

  • @IsroNasa-r5m
    @IsroNasa-r5m Год назад

    I love it

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

    Hello Kevin. Could you tell me how to open 2 spreadsheets at the same time in Teams/SharePoint files? If we have to transfer data from one spreadsheet to another, it's very clunky to open, close, open, close to pull and enter data into separate spreadsheets. Thank you so much. Shout out from Redmond! Sharing your info in our company.. We love your lessons.

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

    Thank you

  • @amosmuvona4347
    @amosmuvona4347 4 года назад +2

    Thank you so much.

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

    Superb,just too good

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

    Hey, this is a cool video .
    Smart way to use Excel .

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

    Thank you🤩

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

    Sir Amazing

  • @rajiblochanswain2896
    @rajiblochanswain2896 6 месяцев назад +1

    Today is my exam and may this video help me😅🙏

  • @lealoveees
    @lealoveees 4 года назад +4

    I always use ALT+H BA and ALT+H BT

  • @Suzukii-Krypto
    @Suzukii-Krypto 2 года назад +1

    Thanks for your video.
    Are there keyboard shortcuts for moving pasted images to the back or to the front? Thanks in advance.

  • @thirikyaw7701
    @thirikyaw7701 4 года назад +2

    Thank You so much for your sharing .

  • @EvanSarris
    @EvanSarris 3 месяца назад

    One problem with Excel 365 is when you click on a cell and copy the text, it sometimes disappears when you switch to another sheet or if I have to change a different cell before I paste the text. More often than not, I have to go back and copy again. I have also noticed when I click on a cell with the text I want to copy, if I put the cursor into the text bar above and highlight the text before copying it, I can paste the text as many times as I want. Even from sheet to sheet.

  • @jessicasandipa5302
    @jessicasandipa5302 4 года назад +2

    amazing

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

    thank u so much

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

    Soo smooth

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

    thank you!!!

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

    its helpful , and useful but how I'm going to memorize all of them it will take lots of time to do but better to understand it first and practice 😅

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

    Thanks Kevin, Great RUclips. Is there a shortcut to add the Date and time in 2-columns at the same time?

  • @vijaykumar-nt3hd
    @vijaykumar-nt3hd Год назад

    Thank you so much ✔️👍

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

    thanks a lot

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

    Kevin great video. Ques. what formula to subtract between cells using a large volume of values. ex, cell A1 minus cell C1 with answer in B1. repeating like that again with values in D1 minus F1 with answer in E1? repeating . I am wondering how to tell excel to just subtract into the empty cells between the two values

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

    Is there a screen recorder that allows you to show the keyboard and the keys you select?

  • @suryabhai8813
    @suryabhai8813 4 года назад +2

    Hi Kevin , thank you for the video.could you please explain about Excel VDB and how to use it?

    • @KevinStratvert
      @KevinStratvert  4 года назад +2

      Thanks for the suggestion Surya! I'll add it to my list of videos to create. Cheers!

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

    How do you delete a sheet with a shortcut? God video!.

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

      RAOP PACHECO Good not God

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

      ravel bella 👎🏽👎🏽👎🏽

  • @hussainfawzer
    @hussainfawzer 4 года назад +2

    I knew it all...
    But I’m new to excel!

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

    If I have a number that is 17 digits long but I only want to sort by the last 6 digits. How do I break up these 17 digits?

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

    thank you. please teach how to create attendance, new version

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

    His Kevin,
    I think this is begginer tutorial. There are more advanced shortcuts.
    I’m waiting for this tutorial (for example: Ctrl+Alt+V = paste special or Ctrl+double C = pane window) 👁

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

    How many shortcuts are there in total?!? Thanks for sharing.

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

    I have been trying to use Excel on my Samsung Galaxy S7 Tab FE, and I am not afraid to say; I need assistance!