Back to Blog
Open power query in excel5/28/2023 ![]() ![]() Many times, great discovery is “discovered” by kind of… mistake. 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. ![]() Power Query Editor did the zoom-in for me, with the same hotkey CTRL+SHIFT+= (coincidentally). That means I was not using Zoomit to zoom-in my screen. « Prev Excel Shortcut Move Left Between Non. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts. OH NO… I had not launched Zoomit before I pressed the hotkey. Our goal is to help you work faster in Excel. The zoom effect was different from the usual one and I could not draw on it. 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 can also set customizable hotkeys for different actions. 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. Right-Click on your Excel desktop icon Right-Click on the Excel menu item Select Run As Administrator Click Yes if a Windows warning dialog pops up Once you have opened up a second instance of the Excel Application, you can proceed to open up Excel files using the Open dialog menu. I use Zoomit to zoom-in my screen during training. Click the gear icon on the Navigation step and navigate to the dataflow entity. In the Data column for Workspaces, click 'Folder'. Open an Excel file > Click Data tab in Excel ribbon > click Get Data dropdown under the Get & Transform Data section. Query: let Source PowerPlatform.Dataflows (null) in Source. Community: heres the full query and screenshots to assist. ![]() In case you don’t know… I am an in-house Excel trainer (volunteer) for my company. This will make a lot of Excel users happy. 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… ![]()
0 Comments
Read More
Leave a Reply. |