How to Reverse Data in Columns on Excel: Excel Data Spread

Understanding Excel data spread requires more than a headline. The overview below breaks down the key facts, changes, and user impact.

• How to rank on Excel with RANK function
• How to arrange incremental dates in Excel
• How to arrange names in alphabetical order in Word

Instructions for Reversing Column Data on Excel

Step 1:

Suppose we have the data column A needs to be reversed as shown below. Now in column B, enter the corresponding order for the data of column A, from 1 to the end. Then we will proceed to sort the data in column A by column B. Just reverse the order of column B, the data in column A will be reversed. This is the purpose of adding data order to column B.

Step 2:

Black out the entire content and then click on the Data tab in the ribbon bar above, click on the Sort tool to open the data sorting table.

Step 3:

Display the data arrangement interface in Excel. Here the user selects the area to be inverted, here is column B at Sort by. Order will choose Largest to Smallest. Need to remove the check in My data has header because the data table has no title. Finally click OK to apply.

Column B and Column A results are both inverted according to the corresponding data.

• How to arrange alphabetical order in Google Sheets
• Instructions for setting the default font in Microsoft Word
• Use VLOOKUP to join two Excel tables together

I wish you all success!