HomeApplicationOffice information

How to reverse data in columns on Excel

When working with documents on Excel, there will be requests that users need to rearrange the data, such as alphabetically ordering names or reversing the list of data in a column or a row to match it. order. If the request in the table is just reversing the data without sorting in alphabetical order, the implementation is extremely simple and immediately use Sort sort tool on Excel. The following article will guide you how to reverse the list in the Excel column.

  1. How to rank on Excel with RANK function
  2. How to arrange incremental dates in Excel
  3. 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.

How to reverse data in columns on Excel Picture 1

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.

How to reverse data in columns on Excel Picture 2

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.

How to reverse data in columns on Excel Picture 3

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

How to reverse data in columns on Excel Picture 4

See more:

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

I wish you all success!

3.5 ★ | 2 Vote

You should read it

May be interested

  • How to delete, add columns in ExcelHow to delete, add columns in Excel
    adding columns in excel or deleting columns is a basic operation and very simple in excel when we process excel tables.
  • How to convert data from columns to rows in excel is extremely simpleHow to convert data from columns to rows in excel is extremely simple
    is there a way to turn a column into a row instead of having to retype the data? very simple with the following 2 ways, tipsmake with you through the article below
  • How to delete rows and columns in Excel with mouse or keyHow to delete rows and columns in Excel with mouse or key
    excel is an important and indispensable tool in the work process. however, editing data or deleting rows and columns in excel can be quite complicated for some new users. therefore, to help make work more efficient, we will introduce to readers how to delete rows and columns in excel using the mouse or keys in detail in the article below.
  • How to Compare Data in ExcelHow to Compare Data in Excel
    this wikihow teaches how to compare different sets of data in excel, from two columns in the same spreadsheet to two different excel files. highlight the first cell of a blank column. when comparing two columns in a worksheet, you'll be...
  • How to split first and last names into 2 columns in ExcelHow to split first and last names into 2 columns in Excel
    how to split first and last names into 2 columns in excel. in the process of compiling data, sometimes you need to split the first name column into two first and last column columns to serve different purposes, for example, to sort the list by alpha b. thuthuatphanmem.vn will be directed.
  • How to Sort Excel Columns AlphabeticallyHow to Sort Excel Columns Alphabetically
    microsoft excel is a great tool for organizing data. this article will introduce to you a simple but extremely useful feature, which is sorting data in alphabetical order.
  • How to fix columns and headlines in ExcelHow to fix columns and headlines in Excel
    why is it necessary to fix lines in excel. for those who often work with excel files with a large number of records, it is impossible not to use it. the following article details how to fix columns and rows in excel 2013.
  • How to Add Columns in a Pivot TableHow to Add Columns in a Pivot Table
    today's tipsmake will show you how to create and insert new columns into a pivot table on microsoft excel using the pivot table tool. you can change existing rows, fields, or data into columns, or create columns of calculated data using custom formulas.
  • Types of data hiding in Excel - Hide pictures, graphs, rows, columnsTypes of data hiding in Excel - Hide pictures, graphs, rows, columns
    tipsmake introduce to you part 3: how to hide photos, graphs, drawings, lines, columns in excel
  • Tips for quickly calculating Totals in ExcelTips for quickly calculating Totals in Excel
    tips for quickly calculating totals in excel

Office information