How to Reverse the Order of Columns in Excel

You can use the Sort option within the Data tab in Excel to quickly reverse the order of columns in a spreadsheet.

The following step-by-step example shows how to do so.

Step 1: Enter the Data

First, let’s enter the following dataset in Excel that contains information about various basketball players:

Step 2: Create Helper Row

Next, we need to create a row at the bottom of the dataset that includes a list of values ranging from 1 to the largest column number:

Step 3: Reverse the Order of Columns

Next, highlight the cell range A1:C12 (this includes the helper row) and then click the Sort icon within the Data tab:

In the new window that appears, click the button titled Options:

In the new window that appears, check the button next to Sort left to right and then click OK.

Excel reverse column order

Next, choose Row 12 for the Sort by dropdown and Largest to Smallest for the Order dropdown:

Once you click OK, the order of the columns will be reversed:

The Team column is now last and the Assists column is now first.

Feel free to delete the helper row now that the columns are reversed.

Additional Resources

The following tutorials explain how to perform other common tasks in Excel:

How to Reverse Order of Rows in Excel
How to Get Distinct Values in a Column in Excel
How to Stack Multiple Columns into One Column in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *