Quick tip – Zoom in and out of the #PowerQuery editor

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…

Zoom InOut in the PQ Editor in Excel

… 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? 😅

About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips, Power BI Desktop, Power Query and tagged , . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.