Subscribe to our YouTube Channel for more Videos

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

Senthil Kumar B
Senthil Kumar is a former Microsoft MVP (Most Valuable Professional). He is a Co-Author of the book "Windows 10 Development Recipes using JavaScript and CSS" for Apress Publication. He is a technical presenter, blogger, mentor and a Geek.  Senthil is a regular speaker is various local user groups. He has presented at conferences like Great Indian Developer Summit (GIDS) & Microsoft DevCamps. You can reach out to him via his Twitter handle @isenthil.