In both #Excel and #PowerBI

Did you know… we can ZOOM IN or zoom out everything but ribbon in the Power Query Editor in both Excel and Power BI Desktop…

… by pressing

• CTRL+SHIFT+=
• CTRL+SHIFT+-

respectively.

The story behind the discovery

In case you don’t know… I am an in-house Excel trainer (volunteer) for my company.  I use Zoomit to zoom-in my screen during training.  I find the application really great; especially for training/demonstration purposes via virtual meeting as I can zoom-in any area of my screen, draw on it, put pointers, etc…  All kinds of basic stuff but super helpful and easy to use.  I can also set customizable hotkeys for different actions.  E.g. I set CTRL+SHIFT+= to start a live zoom.

One day, when I was working on Power Query Editor, I tried to look “more clearly” so I pressed CTRL+SHIFT+= as usual trying to make things “bigger”.  I soon realized something strange.  The zoom effect was different from the usual one and I could not draw on it.  OH NO… I had not launched Zoomit before I pressed the hotkey.  That means I was not using Zoomit to zoom-in my screen.  Power Query Editor did the zoom-in for me, with the same hotkey CTRL+SHIFT+= (coincidentally).  What a pleasant surprise!  I called that the Discovery of the day and could not help myself not to Tweet it the next day after the discovery.

Many times, great discovery is “discovered” by kind of… mistake.  Isn’t it? 😅