Pinterest Pixel

Comment In Query Steps In Power Query

Power Query lets you perform a series of steps to transform your messy Excel data. And if... read more

Download Excel Workbook
Bryan
Posted on

Overview

Power Query lets you perform a series of steps to transform your messy Excel data. And if you have a whole lot of steps, you can add your own comment in query steps in Power Query!

This will make it easier for you to understand your query, or if another person will use it, they can pick it up quickly!

Let’s go through the steps in detail:

Comment In Query Steps In Power Query | MyExcelOnline

download excel workbook Comment-in-Query-Steps.xlsx

 

STEP 1: Let us edit an existing query that we want to modify.

Go to Data > Get & Transform > Show Queries

Delete Steps Until End In Power Query

Double click on your Query to open the Power Query Editor.

Delete Steps Until End In Power Query

 

STEP 2: We want to add a comment to one of our steps. Right click on the step that removes the top rows and select Properties:

Comment In Query Steps In Power Query

 

Since this step removes the first two months, type in the Description “Remove January and February” and click OK.

Comment In Query Steps In Power Query

You have saved your first comment in Power Query! You can repeat the same steps for other query steps as well.

 

How to Comment in Query Steps in Power Query

 

Free Excel Macros & VBA Webinar Training

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Comment In Query Steps In Power Query | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!