Add Shortcuts to Ribbon in Excel - Speed Up your Excel Workflow using the Quick Access Toolbar

Поделиться
HTML-код
  • Опубликовано: 9 июн 2024
  • Speed up your Excel workflow by adding shortcuts to the Ribbon in Excel. Personalize the Quick Access Toolbar and arrange icons for the commands you use most frequently. Get to your favorite commands and shortcuts in fewer clicks by adding them to a custom group on any tab in Excel. In this example, we create a custom group on the Home tab next to the font area on the Ribbon where we place the Strikethrough command.
    Learn how to speed up your Excel workflow by adding custom shortcuts to the ribbon in this comprehensive tutorial. In this video, we guide you through the process of personalizing your Excel experience, reducing clicks, and optimizing your Quick Access Toolbar.
    From adding strikethrough commands to renaming groups, we cover every step to streamline your Excel tasks efficiently. Follow along as we demonstrate how to navigate Excel's options menu, customize the ribbon, and create personalized shortcuts tailored to your workflow.
    Whether you're a seasoned Excel user or just getting started, this tutorial offers valuable insights to boost your productivity and proficiency in Excel. Don't miss out on these essential tips to elevate your spreadsheet game! #exceltips #exceltutorial #excelshortcuts
    TIMESTAMPS ⏰
    00:00 Add Shortcuts to Ribbon in Excel
    00:10 Apply Strikethrough Command - Long Way
    00:35 Create Custom Group on Home Tab in Excel
    01:46 Rename Custom Group on Excel Toolbar
    COURSE 🎒
    Create Fillable Forms, Surveys & Questionnaires in Microsoft Word like a Pro: • Creating Fillable Form...
    WATCH NEXT 📺 Create a Date Countdown in Excel: • Create Date Countdown ...
    CHANNEL LINK 📺
    / @sharonsmith
    Visit my Channel page on RUclips to see all my videos, playlists, community posts and more!
    TEMPLATES 📄
    Check out my helpful list of templates available for purchase: creatoriq.cc/43c51cv
    Thank you for supporting my channel! 🌟
    FREE DOWNLOADS ⬇️
    ✦ Visit mailchi.mp/6a0859ea0844/sharo... to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
    CONNECT WITH ME 📎
    Visit my website: www.sharonsmithhr.com for more information, tools and resources.
    LinkedIn: / sharonsmithhr
    Twitter: / sharonsmithhr
    Instagram: / sharonsmithlearning
    Facebook: / sharonsmithlearning
    GEAR ⚙️
    🎙 Blue Yeti USB Microphone: amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
    🖱 Silent Mouse: amzn.to/3pxpc25 (This is a really cool mouse!)
    🎥 Screen Recording Software: techsmith.z6rjha.net/NZG5b
    📗 Green Screen: amzn.to/2DnHsY2
    📸 Camera: amzn.to/39KvpQA
    🔌 Live Stream Tool: amzn.to/2VFJyID (Turns your DSLR into a top notch webcam)
    RESOURCES 📚
    ✏️ JotForm: www.jotform.com/pricing/?utm_...
    🖥️ TechSmith Camtasia Screen Recording: techsmith.z6rjha.net/SharonSm...
    📑 Wondershare PDFelement (PDF Editor): bit.ly/31QEkA8
    💻 PresenterMedia: shareasale.com/r.cfm?b=417324...
    Links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
    SUPPORT THIS CHANNEL 🙌
    - Hit the "$Thanks" button on any video, or
    - Donate through my PayPal link: www.paypal.com/cgi-bin/webscr...
    If you found this content helpful, please consider donating to my channel. Your donation, no matter what amount, is greatly appreciated and goes towards producing more content that enhances your productivity and elevates your skills.
    You can also support my channel just by watching, liking, and sharing all my videos! Thank you so much! ❤️
    PLAYLISTS 🎥
    ➤ Jotform Tutorials: • Jotform Tutorials
    ➤Create A Letterhead in Word: • Create A Letterhead in...
    ➤Creating Fillable Forms: • How To Create A Fillab...
    ➤PowerPoint Tutorials: • PowerPoint Tutorials
    ➤ Excel Tutorials: • Microsoft Excel Tutorials
    ➤ Excel Tips & Tricks: • Excel Tips & Tricks
    ➤ Word Tutorials: • Microsoft Word Tutorials

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

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

    Let me know which commands & shortcuts you use most often in Excel!

  • @fisheye42
    @fisheye42 12 дней назад +1

    Wow, this is fantastic. Configuring the Tabs/Groups is not very intuitive to me, but you nailed it. I also added Freeze Panes in my new Group. Several other people incorrectly said "you can't add Strikethrough to the ribbon." Your method rocks! (Also note that Mac and Windows Excel can use Control+5 to toggle a cell's Strikethrough, but I might not remember that shortcut.) 🙂 Thank you!

    • @SharonSmith
      @SharonSmith  11 дней назад

      Thanks so much for sharing the shortcut tip! So glad you found this video helpful! Thanks for watching!

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

    I tend to use certain equations, is there a way to make that a button.. so like =if(isblank(a1),””,23