Rearrange Columns in Excel Sheets Using the Sort Wizard

Sometimes we need to re-arrange (sort) the columns rather than rows of our data in Excel. For instance, we may need to see the Customer ID column in a 10-column table as the first column followed by his Order ID because we are more concerned with this piece of detail in our current analysis task.

That said, a lot of us are not aware that we can sort columns the same way we sort rows in Excel. You just need to insert a new row with numbers of each column sort order. Then, with the Sort wizard, switch the sort options to “Sort left to right”.

Watch the video for the steps.

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply