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

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply


x

Interesting BlogPosts to read

How to change orientation of the worksheets in Microsoft Excel ?
This blog post will show the steps that are needed to change the orientation of the current workshee...
How to hide page breaks in worksheets in Microsoft Excel ?
When the page breaks is used to adjust the print area in a worksheet in excel , this would show up a...
How to protect all worksheets at once in Excel using VBA ?
Assume that you have a worksheet and you wish to protect all of the worksheets with a password at on...