20 Excel Shortcuts to Save You HOURS of Work

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

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

  • @KenjiExplains
    @KenjiExplains  2 года назад +33

    🚀 Download FREE Excel Graph Templates from Hubspot: clickhubspot.com/gkx

  • @dominatorgaming2980
    @dominatorgaming2980 Год назад +82

    One recommendation - Don't join any coaching centres for learning excel, Just watch his all videos you will be knack of in excel. What he teaches are very practical, Want more videos 👍👍👍👍❤️❤️❤️

  • @SwahiliSpicE
    @SwahiliSpicE 13 дней назад +2

    Definitely a lot to learn from these shortcuts. My tip would be to use
    Ctrl + shift + v for paste values. I use it everyday

    • @barnacles1804
      @barnacles1804 6 дней назад +1

      Thank you! Alt wasnt working for me, it was just zooming in.

  • @BURTONizAjerK
    @BURTONizAjerK 9 месяцев назад +27

    I consider myself a pretty strong excel user. This video was invaluable for me, this video will help me save some time at work. Thanks for putting this together man.

  • @godofthebiblespeaks3188
    @godofthebiblespeaks3188 Год назад +26

    This video is like gold! I love Excel but there were many shortcuts that I wasn’t aware of. Thanks for posting!

  • @edumas8706
    @edumas8706 Год назад +11

    Very compact, no fluff presentation. An easy 9.5/10.

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

    Thanks

  • @doristhecoder765
    @doristhecoder765 Год назад +17

    I promise you if we are ever in the same location, I will buy you lunch or coffee! You taught me so much!!!! :)

  • @Spratik1_2_6
    @Spratik1_2_6 10 месяцев назад +15

    00:06 These Excel shortcuts can save you hours of time.
    01:44 Excel shortcuts for navigating and editing data quickly
    03:24 Excel shortcuts for efficient navigation and formatting
    04:56 Save time with Excel templates for visualizing data
    06:40 Excel shortcuts to copy and paste values and perform formatting
    08:15 Use shortcuts to quickly format cells and replicate steps.
    09:53 Filter data using Excel shortcuts
    11:34 Using large function for ranking in Excel

  • @michaelsamazingenglish8580
    @michaelsamazingenglish8580 Год назад +6

    This is the most useful video I've seen on Excel here on RUclips. Thank you! Great job!

  • @Adam_K_W
    @Adam_K_W 2 года назад +17

    For #8, you should use the alternate drag and drop function. Simply select the data, mouse over the border of the selected data to get the 4 way arrow, right click, drag and let go where you want to drop, then select "paste here as values"

  • @morganwilson641
    @morganwilson641 2 года назад +206

    Alt + E + S + V will give you paste as values a tiny bit quicker

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

      Niceee

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

      Yes

    • @suehallstrom3666
      @suehallstrom3666 Год назад +20

      Carl alt v even quicker

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

      @@suehallstrom3666 that’s what I was coming to say! Game changer

    • @kevinbush4300
      @kevinbush4300 Год назад +6

      Alt, E, S, V is a legacy shortcut, i think... pre-2013, maybe even earlier.
      Alt, H, V, V would be the equivalent now.

  • @nektarsolne4niy804
    @nektarsolne4niy804 Год назад +39

    Why is nobody mentioning F2 key? This works in Windows in general, but it's so helpful to use in Excel to modify cells. Just use F2 and your cursor will immediately go to the last character of the cell you're in.

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

      thanks for the tip

  • @sixmilsix
    @sixmilsix Месяц назад +2

    Very helpful a few I did not know

  • @entruth6206
    @entruth6206 18 дней назад

    What a great video! Thank you!

  • @alfredrudolph3981
    @alfredrudolph3981 6 месяцев назад +4

    Thanks you for the videos. For Tip Number 8, try ctrl + shift + v to paste only the value

  • @JUDITHSIMO-f6p
    @JUDITHSIMO-f6p Месяц назад

    Thanks a lot for all these

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

    epic man. thanks for that. thumbs up for non clickbait

  • @Skitsfosho1
    @Skitsfosho1 Год назад +3

    I loved the Formula 1 Sales Person list!! Huge fan! Your videos are very insightful and easy to follow.

    • @MuhammadDanish-r9x
      @MuhammadDanish-r9x 8 месяцев назад

      total agree Sir.. This one tutor is so so best to explaining the each step, and his accent is very well, thank to you dear Owner of the video :)

  • @MyRockMyFortress
    @MyRockMyFortress Месяц назад +1

    Alt Down Arrow is cool. I never heard of it.

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

    Thanks for sharing this tip

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

    Great, thanks

  • @solomonbhandari-young4154
    @solomonbhandari-young4154 2 года назад +2

    Kenji always killing it

  • @deemaalwahaibi3050
    @deemaalwahaibi3050 4 месяца назад

    thanks, your channel is what I need

  • @davidmelinda2162
    @davidmelinda2162 10 месяцев назад

    This is very useful thank you

  • @Joshisanalcoholic2024
    @Joshisanalcoholic2024 2 года назад +24

    Your vids are absurdly helpful. Am currently a junior in college studying finance. Trying to get an edge over my peers, this helps a ton

    • @princecamm
      @princecamm 9 месяцев назад +1

      wer u at now

  • @GopeshSharma-nq6cd
    @GopeshSharma-nq6cd 7 месяцев назад +1

    Thank You for such informative video- Crisp and Clear

  • @ThatAyoBankole
    @ThatAyoBankole 4 месяца назад

    Thank you, Kenji!

  • @mdiradshaikh7719
    @mdiradshaikh7719 10 месяцев назад +1

    3:17 Kenji literally made F1 drivers.....beverage salesmen.😂
    Not kidding but this video is actually very helpful.😉👍

    • @KenjiExplains
      @KenjiExplains  10 месяцев назад +1

      Hahaha glad someone noticed 😂😂

  • @miskalhakeem
    @miskalhakeem 8 месяцев назад +5

    Tip for future videos INCASE you dont already do that is the leave the shortcut on the screen for the remainder of the explanation of it. Cause it disappears too quickly

  • @wolfgangi
    @wolfgangi 4 дня назад

    for tip 8, is there a way to copy the entire column and also preserve the same formula within ?

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

    This is great. It will help me a lot

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

    thanks for these tips... 👍

  • @evicabartoskova5208
    @evicabartoskova5208 8 месяцев назад +1

    Hello there
    In shortcut 10 to separate first name and last name in different columns Ctrl+E doesn’t work must be something else to do before the shortcut but I don’t know what? Please could you help me with that?

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

    thank you Mr. kenji for your effort and all your amazing video its useful for us. but can ask you about back music its interrupt us we not native English listener . could you mute it ,chalk if you can please

  • @JaisonMathewJacob
    @JaisonMathewJacob 10 месяцев назад

    Many thanks for this video!! God bless!!

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

    THANK YOU KENJI!!! 🤩

  • @ryyyyy2010
    @ryyyyy2010 8 месяцев назад

    Really helpful man!

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

    Hats off to you Sir Kenji!

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

    Thanks so much

  • @Lord26614
    @Lord26614 4 месяца назад

    Bro I love you for this video. Be blessed and healthy ♥️

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

    The last one is dope! 👌🏻😂

  • @CJJamieson-gq2tj
    @CJJamieson-gq2tj Год назад

    #1 Quick access toolbar. Freeze pane short cut.

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

    dude alt equals just changed my life

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

    Can you make some Microsoft access videos

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

    I like the way you make everything look so easy

  • @jamescarew8525
    @jamescarew8525 2 месяца назад

    dope!, thank you brother :"}

  • @RohitThakur-en7qw
    @RohitThakur-en7qw Год назад +1

    Hey Kenji in my Laptop i am unable to Switch between Sheets by Pressing Ctrl + page up/down. Is there any another shortcut??? Please Check

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

    Thanks!!

  • @raokh.715
    @raokh.715 8 месяцев назад

    Hi Kenji can we also freeze the first column along with the first row in a spreadsheet, and any way to freeze other rows or columns (other than the first)?

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

    You just earned yourself a subscriber on the first video.

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

    Wow great tips!!

  • @KChrisWatching
    @KChrisWatching 10 месяцев назад

    Is F4 (replicate last step) same as control Y ? Btw thank you so muchhh! Great video!

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

    Love your videos. Thanks for sharing, keep it up!

  • @william_acca
    @william_acca 2 года назад +6

    Hi! Mr.Kenji. Thanks so much indeed for sharing. All your lessons are very much beneficial and useful to me. Wish you a happy new year, and many many prosperous and successful years ahead. 🙂❤👍👍👍

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

    Great time savers

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

    alt h v v for paste values as well

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

    thanks a lot. can you please share a pdf of the shortcuts?

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

    Great video. Thank you

  • @sohambansal4175
    @sohambansal4175 Год назад +3

    for adding a row, i use alt+I+R. for adding a column, I use alt+I+C. for pasting values, i use alt+h+v+v

  • @yousseffarachi9422
    @yousseffarachi9422 4 месяца назад

    Thank you dear

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

    Thanks a lot!

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

    Flash fill let’s goooo

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

    Thank You So Much 🥰.

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

    Great content as always! Thank you very much.

  • @JohnDoe-ed7vw
    @JohnDoe-ed7vw 7 месяцев назад

    I love Alt+Down Arrow tip,
    but the last two shortcuts don't work, I even searched and can't find anything, one of them seem related to some 3rd party app, the other is also a mystery, this video seem to be for an old excel version? if anyone figured them plz let me know

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

    Thank you

  • @carrieng4272
    @carrieng4272 4 месяца назад

    can you do a video on short cuts with mac keyboard vs pc?

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

    Thanks bro

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

    #17. Ace !!

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

    Thanks Sir

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

    6:11 They are definitely not a salesperson 😂😂😂😂

    • @ShubhamGupta-cf7yx
      @ShubhamGupta-cf7yx 3 месяца назад +1

      6:05 , so that's what they do off the race 😂

  • @evicabartoskova5208
    @evicabartoskova5208 8 месяцев назад

    Hello there
    Could you please help me with shortcut where you want to live comment on row or cell
    This your shortcut have something else before and I don’t know how to do it?
    Thanks

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

    alt W F R freeze pane

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

    Very helpful but ctrl one does not work to change currency? I have excel 2010

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

    Muchas gracias. Buscando sus correspondientes en español.

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

    Thank u so much

  • @hxjdjdn6236
    @hxjdjdn6236 10 месяцев назад

    Some of these just becomes second nature, but hands on heart who remembers some random letter combinations when you could just click 😂

  • @haidyray1912
    @haidyray1912 2 месяца назад

    Your great

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

    Thank you for the very informative video. I only met 1 problem when trying all 20 shortcuts. When I used Ctrl + space it selects the whole spreadsheet instead of selecting the column. What could be the problem with my excel?

  • @user-qf2jc7kl3u
    @user-qf2jc7kl3u Год назад

    Hi hoping you can help me, I have 10 candidates who all work monday to friday and also clean 7 different types of rooms at varying pay rates, how I can I show the breakdown of how many rooms each person has cleaned each week and what the total pay should be ?

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

    Very helpful video!

  • @dr.jallohinnovativechannel
    @dr.jallohinnovativechannel Год назад

    Thanks for the shortcuts. Very informative.
    Question::
    If I want to highlight an entire roll and then check subsequent roll but still remain highlighted using the down arrow, what is the shortcut or syntax for such?

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

    Hallo! Thank you for this tutorial, you make me smarter and easier working in excel.
    However, i have some issues:
    1. why i cant do the jump to other sheet ctrl + page down or even by using FN
    2. i also find we are difference in checking formulas of "intern", when i do enter ctrl + ' i got the formula but no arrow appears also the formula shown only when i still in the cell, when i move, the shown formula does not came out again
    3. the other one, i am also trying the F4 formula to copy the format, but pity it does not work in my excel.
    why and what is the solution for that?
    i am using windows 11 and my microsoft no account , i dont know why because my IT dept sett it.
    even my windows button can not work also.
    Thank you for helping me, hope your day brighter and full of love 😍 😍

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

    Alt+ T+ U+ T is something new

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

    very handy shortcuts mate! keep it up!

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

    Useful video

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

    Do you know of a template excel 2010 with active stock price?

  • @Muhammad_Asif_Pk
    @Muhammad_Asif_Pk 8 месяцев назад

    Sir for inserting row and column Correct shortcut is CTRL + PLUS instead of CTRL + SHIFT+ PLUS

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

    soo clear brilliant😍

  • @jenkana
    @jenkana 2 месяца назад

    Cntrl shift plus worked once but when I tried again its not working 😢

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

    excellent

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

    1st trick useful

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

    ohhhhhhhhhhhhhhhhhhh myyyyyyyyyyyyyyyyyyy goddddddddddddddddddddddddd !!!!
    what a epic video

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

    Well done
    Thank ☺️☺️☺️👏❣️❣️

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

    That's great😊

  • @maricelagutierrez816
    @maricelagutierrez816 10 месяцев назад

    F4 to copy the same format didn't work for me. It switches my tabs instead.

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

    Do you know how to create a food cost calculator?

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

    How can i use the Alt in MacBook?

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

      unfortunately it doesnt exist...there's no replacement key for it

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

    To find out if there is any common hour (in Column A) at a specific site where cell availability has been below 98.0% for the last 3 days (from 07/09/2023 to 09/09/2023) within the given ranges,