Want to become an expert in VBA? So this is the right place for you. This blog mainly focus on teaching how to apply Visual Basic for Microsoft Excel. So improve the functionality of your excel workbooks with the aid of this blog. Also ask any questions you have regarding MS Excel and applying VBA. We are happy to assist you.

How to Add Power Query to Excel Ribbon


In this post I will show you how to add  power query to Excel ribbon.

First, open the Excel application. Choose blank workbook.






















So new workbook will be created. then click on the file menu.

















Then click on the options.





























Then Excel options window will pop up. Click on Add-Ins
























Then select “Microsoft Power Query for Excel” and click OK.
























 Power Query tab will added to the Excel ribbon.














If "Microsoft Power Query for Excel" is not listed in Add-Ins list then you can download it from Microsoft website.

Search google for the Power Query



















Go to the download page. And click on the download button.

















Then select the apropriate file to download according to the bit version.




Contact Form

Name

Email *

Message *

Popular Posts