Learn how to rearrange columns quickly in Excel. If you generate a report regularly and it produces the columns in an order you do not like, the instructions below will ease the chore, especially if you include an XLOOKUP to the process.

Steps to Rearrange Columns:

1. Insert a new row 1.
2. Number the columns in the order in which you would like them to be in the new first row.

3. Select the whole table, including the new first row.
4. Click on the Data tab

5. Click on the Sort button

6. Click on Options

7. Select “Sort left to right”

8. You will notice that “Column” now says “Row”
9. Pull down the Sort by menu and select Row 1
10. Click OK

You’ve now sorted the columns in the proper order.