Share
Today’s quick tip is by far the quickest and most profitable tip of all.
To switch between ribbon tabs or to change to a particular tab, you can use mouse scroll-wheel. Just place mouse pointer on a ribbon tab, and scroll-down or up using your mouse’s scroll-wheel and you can switch between tabs.
Learn more ribbon tips, free ribbon e-book, a bunch of bite sized quick excel tips
Share this tip with your colleagues
Simple, fun and useful emails, once per week.
Learn & be awesome.
Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME. Read my story • FREE Excel tips book
From simple to complex, there is a formula for every occasion. Check out the list now.
Calendars, invoices, trackers and much more. All free, fun and fantastic.
Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.
Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.
Let’s say you have daily data and your boss wants to see the trends by week in month or week in quarter? How do you calculate the week number in a month or quarter? In this article, let me explain the logic and formulas we can use Excel for this.
One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.Â
© All rights reserved.
9 Responses to “Save a ton of time by using Mouse scroll-wheel to Navigate Excel Ribbon”
Great tip Chandoo! I really need to spend some time customizing the ribbon for my needs. One feature I can't seem to find is the old "Links" option where you can see any broken links or outside links in the spreadsheet. Do you know where it is? Thanks!
is there some kind of setting to enable this? - it doesn't work for me, but it might be user error 🙂
You have to have the ribbon pinned down for this to work. To pin or unpin it, double click the ribbon. It saves me alot of space to have it unpinned.
How do you "pin down" the ribbon? I can't get this to work either.
To get this to work, the mouse cursor needs to be in the ribbon area.
Tony
Try the Data, Connections Tab in Excel 2007
Excellent Tip. Really saves a lot of time..................
Mouse wheel scroll works first but then it stopped working. I have repaired office 2010 but still no luck.
- Is it due to some other program installed.
- Do I need to use only one type of mouse
How to enable the scroll to tab through the ribbon when the wheel is scrolled. I like the feaute but it broke so easily and there is no help provided how to enable it.
Really a very nice trick to navigate between the menu bar...