Excel Shortcut Keys | Full Guide

Ғылым және технология

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
Save time and conquer the spreadsheet with these 50 Excel keyboard shortcuts. Get the most out of Excel in Windows with these pro tips.
Follow along with the workbook cheat sheet that I use in this video:
1drv.ms/x/s!AmxrofZZlZ-whIgBL...
Watch more Excel tutorial videos: • ❎ How to use Excel
50 time-saving Excel shortcuts by Microsoft:
aka.ms/50_Excel_Shortcuts
Comprehensive article on all Excel shortcut keys:
support.office.com/en-us/arti...
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
Many users find that using an external keyboard with keyboard shortcuts for Excel helps them work more efficiently. For users with mobility or vision disabilities, keyboard shortcuts can be easier than using the touchscreen, and are an essential alternative to using a mouse.
Notes:
The shortcuts in this topic refer to the US keyboard layout. Keys for other layouts might not correspond exactly to the keys on a US keyboard.
A plus sign (+) in a shortcut means that you need to press multiple keys at the same time.
As full-disclosure, I work at Microsoft as a full-time employee.

Пікірлер: 160

  • @KevinStratvert
    @KevinStratvert3 жыл бұрын

    🏫 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: kzread.info/head/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

  • @salamatuyeabusesay359

    @salamatuyeabusesay359

    9 ай бұрын

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

  • @mohdabdulmateen5159
    @mohdabdulmateen5159 Жыл бұрын

    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.🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰🥰

  • @AndreaGibson-fc7pt
    @AndreaGibson-fc7pt Жыл бұрын

    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
    @gowaymike95093 жыл бұрын

    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 жыл бұрын

    omg this is amazing thank you.

  • @joyabsalon9216

    @joyabsalon9216

    2 жыл бұрын

    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

    5 ай бұрын

    thank you!

  • @joelweiss7013
    @joelweiss70134 жыл бұрын

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

  • @ciaran110505
    @ciaran110505 Жыл бұрын

    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.

  • @dyeninalibut3025
    @dyeninalibut3025 Жыл бұрын

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

  • @ianpatrick23
    @ianpatrick23 Жыл бұрын

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

  • @arthurletim1248
    @arthurletim12482 жыл бұрын

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

  • @meghanb4541
    @meghanb45412 жыл бұрын

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

  • @m.mohtashim2000
    @m.mohtashim20003 жыл бұрын

    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. ♥️😊

  • @dariusanderton3760
    @dariusanderton37602 жыл бұрын

    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.

  • @samueldegraftmintah1226
    @samueldegraftmintah1226 Жыл бұрын

    incredible. So easy to learn. Thanks Kevin

  • @vaibhavsumit7917
    @vaibhavsumit79173 жыл бұрын

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

  • @raquelrodriguez865
    @raquelrodriguez86518 күн бұрын

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

  • @ilove2playgames
    @ilove2playgames10 ай бұрын

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

  • @MrDariusAtl
    @MrDariusAtl3 ай бұрын

    Kevin always come with fire content. 🙌🏾🔥

  • @thomasman1952
    @thomasman19524 жыл бұрын

    Thank You so much for your sharing .

  • @kmiracle9948
    @kmiracle9948 Жыл бұрын

    you are the best!! Learning alot from you 😌

  • @saburjonsaidov2904
    @saburjonsaidov29043 жыл бұрын

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

  • @partapchandra5739
    @partapchandra5739 Жыл бұрын

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

  • @dianaroseprincillo7924
    @dianaroseprincillo7924 Жыл бұрын

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

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

  • @nataliadavila3827
    @nataliadavila38272 жыл бұрын

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

  • @wcarlosw
    @wcarlosw3 жыл бұрын

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

  • @Sayedalishubbar
    @Sayedalishubbar4 жыл бұрын

    thanks for your kind efforts.

  • @johnbutler2750
    @johnbutler27503 жыл бұрын

    The alt shortcut to navigate the ribbon is great!

  • @wcdx1981

    @wcdx1981

    3 жыл бұрын

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

  • @denisethomas6927
    @denisethomas69273 жыл бұрын

    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?

  • @6989yogesh
    @6989yogesh Жыл бұрын

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

  • @KevinStratvert

    @KevinStratvert

    Жыл бұрын

    Ah, that makes sense! Thanks for sharing!

  • @veronicaromero8642
    @veronicaromero86423 жыл бұрын

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

  • @olgacotto7915
    @olgacotto79156 ай бұрын

    Very helpful! Thank you.

  • @balakrishnankamala3744
    @balakrishnankamala3744 Жыл бұрын

    Thank you. It's very much helpful

  • @kanikamaheshwari9732
    @kanikamaheshwari97327 ай бұрын

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

  • @JumpRopeVeteran
    @JumpRopeVeteran4 жыл бұрын

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

  • @amosmuvona4347
    @amosmuvona43474 жыл бұрын

    Thank you so much.

  • @starboy7151
    @starboy7151 Жыл бұрын

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

  • @zombie20x
    @zombie20x Жыл бұрын

    This was really helpful bro thanks

  • @UmairAli
    @UmairAli11 ай бұрын

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

  • @rasgullakhan7973
    @rasgullakhan79737 ай бұрын

    Excellent video.. Valuable content👍

  • @nathanielbalmes6597
    @nathanielbalmes65973 ай бұрын

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

  • @feraidoonerfani6678
    @feraidoonerfani66787 ай бұрын

    enjoyed with the shortcuts.

  • @min9yukimenthusiast
    @min9yukimenthusiast11 ай бұрын

    thank you soooooo much for this!

  • @habibullahalizada6173
    @habibullahalizada6173 Жыл бұрын

    Thank you for your information

  • @wintaendriyas519
    @wintaendriyas5192 жыл бұрын

    Thank u soo much this is very helpful

  • @naanbread1970
    @naanbread19703 жыл бұрын

    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.

  • @buddhinihini6588
    @buddhinihini65883 жыл бұрын

    Thank you so much

  • @threeaxis359
    @threeaxis3592 жыл бұрын

    Thank You you're awesome!

  • @Anikvikram
    @Anikvikram7 ай бұрын

    Thank you for such a nice video 🎉🎉

  • @parbuarcharya9766
    @parbuarcharya97663 жыл бұрын

    thank you so much sir

  • @valeriaouriques
    @valeriaouriques Жыл бұрын

    Thank you teacher!!!!!

  • @sweetlovevlog9573
    @sweetlovevlog9573 Жыл бұрын

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

  • @vijaykumar-nt3hd
    @vijaykumar-nt3hd Жыл бұрын

    Thank you so much ✔️👍

  • @deshanbandara2313
    @deshanbandara23133 жыл бұрын

    Great job..!

  • @Suzukii-Krypto
    @Suzukii-Krypto Жыл бұрын

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

  • @sateshn233
    @sateshn2333 жыл бұрын

    Thanks! Everything except 2 I didn't know

  • @RajaEdits3525
    @RajaEdits3525 Жыл бұрын

    Superb learning Excel shortcuts

  • @RexRaven22
    @RexRaven2213 күн бұрын

    Thank you

  • @mohdosman4154
    @mohdosman41542 жыл бұрын

    great job

  • @jessicasandipa5302
    @jessicasandipa53024 жыл бұрын

    amazing

  • @victorape5688
    @victorape5688 Жыл бұрын

    Interesting. Thanks.

  • @petlover6072
    @petlover60729 ай бұрын

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

  • @brendamartinezgomez2297
    @brendamartinezgomez22978 ай бұрын

    thank you !

  • @anirbanpaul129
    @anirbanpaul1294 жыл бұрын

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

  • @KevinStratvert

    @KevinStratvert

    4 жыл бұрын

    Thanks for the note Anirban!

  • @kathrynwest1072
    @kathrynwest10723 жыл бұрын

    thank you!!!

  • @reddlief
    @reddliefАй бұрын

    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?

  • @salamatuyeabusesay359
    @salamatuyeabusesay3599 ай бұрын

    it's really educative.

  • @ahamedriyas4712
    @ahamedriyas4712 Жыл бұрын

    Thank you🤩

  • @thawthaw3035
    @thawthaw3035 Жыл бұрын

    Thank you Sir Kevin

  • @kalaklah4848
    @kalaklah48483 жыл бұрын

    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

  • @veyseltuncalan8638
    @veyseltuncalan86387 ай бұрын

    You are perfect 👍🏻

  • @rajiblochanswain2896
    @rajiblochanswain289629 күн бұрын

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

  • @satyaswaroopmati6546
    @satyaswaroopmati65462 жыл бұрын

    Sir Amazing

  • @nairozabujrad6977
    @nairozabujrad6977 Жыл бұрын

    thank u so much

  • @hasansani5600
    @hasansani56003 жыл бұрын

    thanks a lot

  • @billjuss5331
    @billjuss5331 Жыл бұрын

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

  • @user-yk1wm3ke8b
    @user-yk1wm3ke8b8 ай бұрын

    I love it

  • @WTPlearn
    @WTPlearn7 ай бұрын

    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.

  • @compound32
    @compound323 жыл бұрын

    Is there a way, with using the Hyperbole Link application I could navigate into links by using CTRL + [any key] sticky keys?

  • @piyushnegi307
    @piyushnegi307 Жыл бұрын

    Soo smooth

  • @lealoveees
    @lealoveees3 жыл бұрын

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

  • @anikchowdhury9708
    @anikchowdhury9708 Жыл бұрын

    Superb,just too good

  • @shivanmohyaddin
    @shivanmohyaddin3 жыл бұрын

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

  • @sunpasirithxssunpasiri4759
    @sunpasirithxssunpasiri4759 Жыл бұрын

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

  • @shaayeqparvez4551
    @shaayeqparvez45513 жыл бұрын

    Nice vid

  • @swethakadem195
    @swethakadem19511 ай бұрын

    Hey Kevin, Do we have keyboard shortcut key to increase the column width like how we drag and adjust the same with mouse

  • @dmatula811
    @dmatula8112 жыл бұрын

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

  • @suryabhai8813
    @suryabhai88134 жыл бұрын

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

  • @KevinStratvert

    @KevinStratvert

    4 жыл бұрын

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

  • @melodyjr8995
    @melodyjr89953 жыл бұрын

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

  • @bryanlunacontreras325
    @bryanlunacontreras3253 жыл бұрын

    Hey Kevin, I'm trying to use this on MacOS, is it possible? I always use those keyboard shortcuts on windows but now i'm in a trouble.

  • @lucky-nz1ll
    @lucky-nz1ll4 жыл бұрын

    Hi Mr. Kevin I am WPS user, then i found out some shortcut keys are not applicable.Anything you can advise?

  • @karenjohnson9855
    @karenjohnson9855 Жыл бұрын

    Curios, do we have the same symbols in MS Word as with excel say for other languages, Spanish , Chinese, or German?

  • @terrorsz75
    @terrorsz753 жыл бұрын

    This was super helpful. Thank you! I actually have one request for a shortcut, I saw it used a few years ago and can't remember what keys to use. So, working if formulas referencing different worksheet there was a shortcut key which is almost like F2 function when the formula cell is selected but it takes you to the actual cell the formula is referencing. Do you know what keys those are?

  • @dariusanderton3760

    @dariusanderton3760

    2 жыл бұрын

    is it a feature or formula called "goto" , and you click on it and then you are taken to a different page or a different cell on the same page ?

  • @terrorsz75

    @terrorsz75

    2 жыл бұрын

    @@dariusanderton3760 Hey Darius, the function I was talking about is CtRL + [

  • @terrorsz75

    @terrorsz75

    2 жыл бұрын

    I stumbled on that from tiktok

  • @gohst101pubg8
    @gohst101pubg82 жыл бұрын

    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 😅

  • @eileenrourke5569
    @eileenrourke55693 жыл бұрын

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

  • @hussainfawzer
    @hussainfawzer3 жыл бұрын

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

  • @edmarquejada8926
    @edmarquejada89263 жыл бұрын

    help me , How can I get the sum of my IMEI and Mac address using MS Excel? After getting the sum and multiplied by 11, how can I execute "nck" calculation in Ms Excel?

  • @bluebox9971
    @bluebox9971 Жыл бұрын

    can you navigate ribbon with shortcut keys on ipad with bluetooth keyboard like a normal pc?

  • @dclarek741
    @dclarek741 Жыл бұрын

    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?

  • @raoppacheco7654
    @raoppacheco76544 жыл бұрын

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

  • @ravelbella7330

    @ravelbella7330

    4 жыл бұрын

    RAOP PACHECO Good not God

  • @dianal9346

    @dianal9346

    4 жыл бұрын

    ravel bella 👎🏽👎🏽👎🏽

  • @Ayuk1
    @Ayuk13 жыл бұрын

    ctrl + 1 not working in my excel 2019 for windows 10. Can you assist please?

Келесі