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.
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.
The following tutorials explain how to perform other common tasks in Excel: