How to Reorder Multiple Columns in Power Query with Drag & Drop

Bottom line: Learn a few quick tips to quickly reorder multiple columns in Power Query without having to move each column individually.

Skill level: Beginner

Power Query Quickly Reorder Multiple Columns

Reordering a bunch of columns in Power Query can be a drag (literally). You might spend extra time moving each column into place. This can be especially time-consuming if you have a lot of columns that you have to drag and scroll across a large table.

In this post I share a few tips to make the process of reordering columns faster.

Download the Excel File

You can download the example file to follow along and practice.

Excel File Icon 2021 xlsx Power Query Reorder Columns.xlsx

1. Reorder Multiple Columns with Ctrl+Select

The easiest way I've found to reorder multiple columns is to select the columns with the Ctrl key and then move them. Here are the instructions.

1. Hold the Ctrl key and select each of the columns in the order you want them displayed. In this example I want the columns to be displayed in the following order, so I select each column in that order.

Order ID, Order Date, Category, Product Name, Unit Price

Power Query Reorder Columns - Ctrl Select Columns in Order

2. Left-click and hold any one of the columns and drag the mouse to the location you want to place the columns.

Power Query Reorder Columns - Drag Columns to Right of Selection

3. Release the mouse and the columns will be reordered based on the order you selected them in step 1.

Power Query Reorder Columns - Multiple Columns Reordered After Releasing Mouse

Important Note: If you end up selecting all of the columns, you will need to drag the selection to the right of the last column, then release. If you drag to the left of the columns, nothing will happen.

2. Reverse Order of Columns

You can use this same basic technique to quickly reverse the order of all (or some) columns.

1. Select the last column in the table, hold the Shift key, and then select the first column in the table.

Power Query Reverse Column Order - Shift Select Last Column Then First Column

2. Left-click and hold the last column and drag the mouse to the right of the last column.

Power Query Reverse Column Order - Drag Columns to Right of Selection

3. Release the mouse and the column order will be reversed.

Power Query Reverse Column Order - Multiple Columns Reordered After Releasing Mouse

Note: You can also use this same technique for reversing the order of just some of the columns in your query. The process is the same, you will just select a few columns within the table. You can also drag the columns to the left if the first column is not part of the selection.

3. Undo or Change the Order

If you realize that the new column order isn't exactly what you wanted, there are a few ways to fix it.

Undo the Reorder

First, you can undo the change by deleting the Reordered Columns step in the Applied Steps window. Then use the select and move technique again with the correct order.

Power Query Reorder Columns - Delete the Reordered Columns Step to Undo

Check out my post on 15 Shortcuts for Power Query to learn how to undo (relatively) quickly.

Manually Refine the Order

If just a few columns are out of order, you can also manually select and drag individual columns to move them. If you do this step directly after the previous step above, then the Reorder Columns step will be modified in the Applied Steps window.

Power Query Reorder Columns - Move Individual Columns

Power Query is smart enough to NOT add additional steps for the reordering, which makes it easier to delete the step if needed.

Modify the Formula Text

Another option is to modify the formula text in the Table.ReorderColumns function that is created for the Reorder Columns step. To me, moving the columns with the mouse is easier because you don't have to worry about getting the syntax with the commas and quotation marks perfect (any typos in the syntax will result in an error).

Power Query Reorder Columns - Modify the Table ReorderColumns Function

However, it's still good to know about this technique because you might have the column order in another file, report, or list somewhere, and you can use that text to quickly modify the column order. This can be especially useful if your table has dozens or hundreds of columns.

Free Webinar on Power Query, VBA, & More

If you're new to Power Query, I have a free webinar running right now that covers an introduction to Power Query and the other Excel tools like Power Pivot, Power BI, Macros & VBA, pivot tables, and more.

Modern Excel Blueprint Training Webinar Excel Campus Jon Acampora

Click here to register for the webinar

Conclusion

I hope these quick tips save you time when rearranging columns in Power Query. Please leave a comment below with any additional tips, questions, or suggestions. Thank you! ๐Ÿ™‚

  • Another way of “automatically” rearranging columns in PowerQuery is to select the columns in the wished order while holding Ctrl key. Then hit the button “Remove other columns”, this will create a Table.SelectColumns step and display the columns in the selected order. Omitted columns will be automatically deleted but the selected order will be still retained.

  • I know I should be able to do this based on the simple instructions but for some reason, it is not working for me. Do you happen to have a video (I know it sounds silly to even ask)

  • Hi Jon,
    I discovered your blog only a few weeks ago, and I really appreciate your refined quick tips. I havenโ€™t used the Power Query as much as I should since I rely on formulas. The ability to re-order columns is beneficial. I agree that editing the formula syntax is complicated since an extra space could create issues. The file you provided as a download is appreciated. I would love to see some of your skills with graphing from Power Query Tables. I find there are some limitations versus using commonly formatted data.
    -Krist

  • Search
    Generic filters
    Exact matches only

    JOIN US & LEARN EXCEL

    Learn 10 great Excel techniques that will wow your boss and make your co-workers say, "how did you do that??"
    Plus weekly updates to help you learn Excel.

    Download the eBook

    Excel Shortcuts List

    keyboard shortcuts list banner

    Learn over 270 Excel keyboard & mouse shortcuts for Windows & Mac.

    Excel Shortcuts List

    Join Our Weekly Newsletter

    The Excel Pro Tips Newsletter is packed with tips & techniques to help you master Excel.

    Join Our Free Newsletter

    About Me

    Jon Acampora Profile

    Hello and welcome! My name is Jon Acampora and I'm here to help you learn Excel.

    This blog is updated frequently with Excel and VBA tutorials & tools to help improve your Excel skills and save time with your everyday tasks. Subscribe above to stay updated. More about me...

    MVP_Horizontal_BlueOnly

    Free Excel Training Webinar Modern Power Tools

    >