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
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? 😅
Great tip, thanks. I’m facing a similar issue with Power Query and your tip helped to zoom out the table. The problem is that the ribbon at the top got also maximized somehow and I can’t make it smaller. Do you know how to solve that?
You are welcome! However i have no answer to your question…