How to reverse the column order in Microsoft Excel ?

This blog post will explain in simple steps on how you can flip or reverse the order of the column data in Microsoft Excel 2016.

How to reverse the column order in Microsoft Excel ?

Assume that you have a data in the column A and you want to reverse the order as shown in the screenshot.

SNAGHTML62731d1

Here’s how you can do it easily using the sort command.

1. Insert the sequence numbers of the columns in the column B as shown.

image

2. Select the column cells “B1 to B4” and navigate to Data Tab and select “Sort Z to A”.

image

3. This would display a “Sort Warning” dialog. Check the radio button “Expand the selection” and click the sort button.

image

4. You will immediately notice that the order of the column A is reversed as shown in the screenshot.

image

Leave A Reply

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

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021