Excel Shortcuts that Will Save You Hours of Work (Windows & Mac)

Поділитися
Вставка
  • Опубліковано 23 гру 2024

КОМЕНТАРІ • 87

  • @MyOnlineTrainingHub
    @MyOnlineTrainingHub  10 місяців тому +2

    ❓Which Excel shortcut do you use the most?
    FREE 239 Excel Shortcuts for Windows & Mac: bit.ly/shortcuts240225

  • @JimFikes
    @JimFikes 10 місяців тому +5

    It's great to see you back up and running. I need to convert ranges with formulas to values almost daily. I right-click on the selected range that has formulas and drag it to where I want it and then choose Copy Here as Values Only,

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

      Oh yes, I forget you can do that too. Thanks for sharing 😊

  • @josh_excel
    @josh_excel 9 місяців тому +2

    F4 repeats the last command for Word, Excel and PowerPoint
    Ctrl+d also duplicates if you have an object selected

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

    I'm a subscriber and was sorry to hear about the security breach. You have educated the public how disruptive a breach can be to one's personal and professional life. Great to have you back.

  • @MyLy-24
    @MyLy-24 Місяць тому

    Great thanks Mynda very helpful especially for those who are learning Excil❤️❤️❤️❤️❤️

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

    Excellent, thanks Mynda. Very helpful especially for people still learning Excel.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  10 місяців тому +1

      Cheers, Chris! Yes, definitely aimed at beginners. Appreciate you taking the time to watch still 😊🙏

  • @Zakayo-l4h
    @Zakayo-l4h 9 місяців тому

    I just came across your channel can't believe I am starting to understand Excel. Highly appreciated 🎉🎉🎉

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  9 місяців тому

      Wonderful to hear! Keep practicing. There's no Excel skills that aren't worthwhile 😉

  • @jpparikh55
    @jpparikh55 9 місяців тому

    Hi Mynda,
    Those are very helpful tips; there is a typo in Tip 23 @ 4:22 cmd+t and the same in Tip29 @ 5:12. This command is for a table but is incorrectly labelled for the Freeze pane. I am interested in knowing the shortcut, however.
    Thanks a lot!!

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  9 місяців тому

      Oops, sorry about that. It should be Command + Option + F.

  • @charnh.4360
    @charnh.4360 4 місяці тому

    Thanks for these shortcuts (& the link). Your vids are really easy to follow and the video editing is great.

  • @FrankLinssenPhotography
    @FrankLinssenPhotography 9 місяців тому

    I use (and already knew) a lot of the tips you show in your video. But what I find a real time-saver as well sometimes is by using the QAT. I've put a lot of usefull commands in there e.g. Paste Values, Paste Formats, Clear Formats, Select visible cells, Paste formulas and many more. And easy to export those settings and import on another PC

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  9 місяців тому

      Great tip! Thanks for sharing, Frank. I love the QAT too 😁

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

    Ctrl+Shift+mouse wheel is amazing . Thank you.

  • @elen_kulilili5048
    @elen_kulilili5048 6 місяців тому

    This is exactly what I'm looking for! Thank you so much🥰

  • @learningwithmaliha
    @learningwithmaliha 7 місяців тому

    Excellent Myanda, to help us work more efficiently.

  • @awill7710
    @awill7710 Місяць тому

    Monday, thank you again for another great video. I just purchased my first MacBook Air but have read the Excel doesn't have full functionality. Do you recommend purchasing a windows laptop instead? If anyone has recommendations please share.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  Місяць тому

      😬sheesh! If you want to use Power Query to automate the gathering and cleaning of data, or Power Pivot to model and work with big data, then I'd definitely get a Windows laptop. The alternative is to install Parallels on the Mac and install Excel for Windows on there. Not sure how annoying this would be though.

    • @awill7710
      @awill7710 Місяць тому

      @@MyOnlineTrainingHub Thank you and apologies for addressing you as "Monday." Autocorrect:(

  • @yokoyama7590
    @yokoyama7590 10 місяців тому +1

    Thank you, this is brilliant! Where were you 20 years ago?

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

    Thanks so much for sharing. It's very useful and handy 🎉

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

    Simply the best. Very useful video for me as I use mac. Thank you.

  • @PraveenKumar-dt3lv
    @PraveenKumar-dt3lv 8 місяців тому

    Been a windows user all along and gonna switch to Mac soon..
    Do you think, it is hard and time taking to adapt to the Excel in Mac ??

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  8 місяців тому

      Oh no! If you want to use Power Query to automate data cleaning and Power Pivot to analyse data, then forget the Mac. Or at least be prepared to install a virtual Windows machine with Parallels or similar so you can install Windows Excel.

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

    Thanks; that’s handy. I’ve familiarized myself with Alt key combinations with home ribbons (Letters).

  • @robhebert5137
    @robhebert5137 10 місяців тому +3

    How have I never known Ctrl+Alt+V???? Thank you!!

  • @ndeeka
    @ndeeka 9 місяців тому

    Nice to see my beloved Alt+W FF. Another favorite of mine is Alt+D FF.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  9 місяців тому

      Trying Alt+D FF now!

    • @ndeeka
      @ndeeka 9 місяців тому

      @@MyOnlineTrainingHub And, what do you think?

    • @Michael_Alaska
      @Michael_Alaska 9 місяців тому

      @ndeeka I tried Alt+D,F,F, also Alt, D, F, F. Something pops up about Office Access Key but doesn't seem to do anything. What should we be seeing?

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  9 місяців тому +1

      @Michael_Alaska I'm not sure what that error is referring to. Try a Google search to see what others have found.
      @ndeeka nice, but I use Tables most of the time and they already have filters applied, so I'm likely to forget it for the rare occasions I need it 😂

    • @ndeeka
      @ndeeka 9 місяців тому

      @@Michael_Alaska it should apply Data filter. Weird you would get a popup. I assume you work in an English Excel environment.

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

    Thank you For Your help..

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

    I am confused with showing absolute and relative references on a Mac your video says cmd+t but this brings up the dialogue box for creating a table. What am I doing wrong

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

      The F4 equivalent on a Mac should be Cmd+t. However, the cell must be in edit mode, or you need to have your cursor in the formula bar for Cmd+t to toggle absolute references.

  • @roywilson9580
    @roywilson9580 10 місяців тому +1

    I love shortcut keys it cuts down on the need to move your hand from the keyboard to the mouse also, unfortunately, I am old enough to remember using computers before the mouse was a standard feature, I still find myself going for the old alt key codes to get to the menus or rather ribbon these days!

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  10 місяців тому +1

      😁 I learned on Lotus 1-2-3 and back then it was all about the backslash!

    • @roywilson9580
      @roywilson9580 9 місяців тому +1

      @@MyOnlineTrainingHub Lotus was a very good spreadsheet program. I think Excel copied over all the worst of Lotus and forgot about the best parts though 😢

    • @ndeeka
      @ndeeka 9 місяців тому +2

      Me too, although I also made my own personal ribbon for the functions I use most. But most users are probably not aware of that option, or they don't care. For me it saves plenty mouse movements (and therefore time) by itself to a level acceptable for me to use the mouse. Still, some short cuts are here too stay.

    • @roywilson9580
      @roywilson9580 9 місяців тому +1

      @@ndeekaYes the ribbon has made it far easier to navigate to commands than the old way of doing it from the menu items where it might be three or four levels deep. I still find it quicker and less disturbing to my work flow to go for the keyboard shortcuts though.

  • @IamTheReaper911
    @IamTheReaper911 10 місяців тому +2

    Most of your videos put me in the ball park of "I wish I knew sooner" 😛

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

      Thanks for watching! Glad you learned something worthwhile 😉

  • @Himanshu0719
    @Himanshu0719 9 місяців тому

    Great video Ma'am
    I've learnt new shortcuts

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

    CTRL+6 is hide shapes, graps, pictures.
    CTRL+W close the current workbook
    ALT+F4 close the excel
    CRTL+* select the corner cells of current region.
    SHFT+Space select the entire row
    CTRL+Space select the entire column
    CTRL+Page up shift the next sheet (CRTL+SHFT+3)
    CRTL+Page down shift the previous sheet (CRTL+SHFT+9)
    SHFT+F10 open the object pane
    SHFT+F8 open the random selection
    ALT+Down+Up Arrow Open the drop down list

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

      Ooh, there's some obscure ones there! Thanks for sharing.

    • @priyeshsanghvi8424
      @priyeshsanghvi8424 9 місяців тому

      @@MyOnlineTrainingHub another obscure but useful one > Ctrl + 8 to hide/unhide (toggle key) outlines used for grouping....useful for saving real estate on excel screen.....and Ctrl+Shift+F1 (toggle) for a fully excel-immersive view

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

    0:05 "I"m not going to cover them all in this video" Awwwww man :( You know we'd watch you talking about all 270 keyboard shortcuts!

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

    F12 to save is a game changer!

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

    Not sure if it's worth mentioning but I believe it's not actually ctrl + 0 and 9 to hide but ctrl + '(' and ')'.

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

      it is ctrl+0, if it is ctrl + ( then you would need to hit the shift key

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

      @Weehawk what @tiongah7690 said. Thank you both for watching 😉

  • @antique-bs8bb
    @antique-bs8bb 9 місяців тому

    👍👍👍👍 F12 - wow I didn't know that. The new save as is awful combined with OneDrive as only hard disk folders are offered and none of the quick access links I set up on Explorer are available. thankyou - Thankyou - THANKYOU
    Control-a is vastly underused. Likewise ctrl-r/d which can also be used on a single cell to copy the cell from the left / above.
    You undersell F4. It does not only do the ctrl-y job of un -un doing. It repeats an action as well.
    So a formatting action can be done on one cell, then another cell or range and yet another with F4.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  9 місяців тому

      Glad F12 will be useful to you. Thanks for highlighting F4's extra functionality. 👍

  • @Tchernosplif
    @Tchernosplif 10 місяців тому +1

    Ctrl+Shift+L to add/remove a filter
    Ctrl+; to add today's date
    Windows+. to open smileys 👍←↑→↓△
    Alt+ letter (quick access keys) for example Alt+E then G correspond to Ctrl+Alt+V
    Ctrl+Return to apply formula bar change to all selected cells
    Shift+ ←↑→↓ to add/remove rows/columns to a selection

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

      Thanks for sharing! I think I covered the last one 😉

    • @josh_excel
      @josh_excel 9 місяців тому +1

      Ctrl+Shift ; to add current time

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

    I use ALT+number to quick access

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

      Yes, great tip! I always forget to use them 🤦‍♀️

  • @humansizedaperture
    @humansizedaperture 9 місяців тому

    I love my control t with a cell selected in the range. And then it goes and just opens a new tab in Edge.

    • @MyOnlineTrainingHub
      @MyOnlineTrainingHub  9 місяців тому

      Hmmm, that's odd. Sounds like Edge was the app in focus, not Excel. I've never seen Excel do that otherwise.

  • @wgalloPT
    @wgalloPT 9 місяців тому

    So pretty and very smart.

  • @nitin9411166
    @nitin9411166 2 місяці тому

    How to ALT +H+O+I in excel mac

  • @bazir1128
    @bazir1128 2 місяці тому

    Not helpful accept control c and z accept that we have to click and edit wasted my 5 minutes