EDUCBA

EDUCBA

MENUMENU
  • Blog
  • All Courses
  • All in One Bundle
  • Login
Home Excel Excel Resources Excel Tips Excel Reverse Order

Excel Reverse Order

By Madhuri ThakurMadhuri Thakur

Excel Reverse Order

Excel Reverse Order (Table of Contents)

  • Introduction to Excel Reverse Order
  • Methods to Reverse Column Order

Introduction to Excel Reverse Order

Reversing the order is nothing but flipping the column values; this means the last value in your column should be the first value in reversed order and the second last should be the second value and going on, the first value should be the one that gets entered at last in a reversed column. Well, it seems to be a pretty simple one-click task when you hear it out at first. However, it is not. Because there is no one-click button in Excel that does this task for you, besides it is really very hard to use the traditional Sort function as it only can sort the values based on the sorting order alphabetically or numerically and not with the flipping preferences. However, these are not the only, and you may come up with some creativity, your own ways to get the task done.

Let us see different methods that can be used to reverse the column order. Suppose we have data as shown below:

Excel Reverse Order 1-1

Column A consists of data, as you can see, that is not sorted. Here, we wanted the order to be reversed (column flip) in a way that Dan should appear first in a Reversed column and then Bob and likewise, Alvin should come as last in a Reversed column.

Methods to Reverse Column Order

Let’s understand the techniques to Reverse Column Order with a few methods.

You can download this Reverse Order Excel Template here – Reverse Order Excel Template

Methods #1 – Conventional Sort Method

Step 1: Add a column named Order after column A (Data) and try typing the numbers starting from 1,2. These numbers will be the order references for data values under column A.

Excel Reverse Order 1-2

Step 2: Now, select the first two cells in the column named Order (column B) and then drag it down until B11 to get the sequential numbers from 1 to 10 across B1:B11.

Excel Reverse Order 1-3

Step 3: Select the entire column B Data (B1:B11) and navigate to the Data tab in the Excel Ribbon. Within the Data tab, under the Sort & Filter group, click on the Sort Z to A (Highest to Lowest) button.

Excel Reverse Order 1-4

Step 4: As soon as you click on the Sort Z to A button, you’ll get a warning message from the function. As shown below. Don’t change anything in the default selection in that message box and click on the Sort button.

Excel Reverse Order 1-5

As soon as you click on the Sort button, you could see that the data has been sorted based on column B (named Order) values as Largest to Smallest and accordingly, column A values have also changed their places. Now, you can see Dan as the first entry in column A, Bob as second and going on, Alvin as the last entry.

Excel Reverse Order 1-6

This is one way to reverse the order of a column or flip the column.

Methods #2 – Using Excel Formula

You can see that column A consists of all the names starting from Alvin up to Dan. Now, column B, named Reversed, is something where we will be adding a generic formula that can look up and add the values as flipped from column A. Which means the sequence will be Dan as first, Bob as second and going so on, Alvin will be the last entry under column B.

Using Excel Formula 2-1

Step 1: In cell B2, start typing the INDEX formula and use $A2:$A$11 as an absolute reference to it (hit keyboard F4 button once to convert the reference into an absolute one).

Using Excel Formula 2-2

Step 2: Now, use the ROWS function to add the relative row references. Use the same data reference inside the ROWS function (A2:A$11); however, this time, use F4 to make A11 as absolute.

Using Excel Formula 2-3

Step 3: Add two closing parentheses for ROWS as well as the INDEX function, and this formula is complete. You can press the Enter key as well as drag this formula across B2:B11 to get the desired result.

Using Excel Formula 2-4

Things to Remember About Excel Reverse Order

  • Excel doesn’t have any built-in function that reverses/flips the column order. It can be achieved with different formulae and their combinations.
  • Excel SORT seems to be the best, simple yet faster way to achieve the order reversal or order flipping of a column.
  • However, at the same time, using a combination of INDEX and ROWS function is more generic since it doesn’t alter the original order preference, and you still can have your values in original order if you changed your mind from flipping the column order.

Recommended Articles

This is a guide to Excel Reverse Order. Here we discuss How to Reverse Column Order in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Trunc in Excel
  2. Compare Two Lists in Excel
  3. Logical Functions in Excel
  4. Sort Column in Excel
MICROSOFT POWER BI Training
48+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
MS Excel & VBA for Data Science
128+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
All-in-One Financial Analyst Masters Training Program
1000+ Hours of HD Videos
43 Learning Paths
250+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
All in One Data Science Bundle (360+ Courses, 50+ projects)
1500+ Hour of HD Videos
80 Learning Paths
360+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Popular Course in this category
MS Excel Course
 223+ Hours of HD Videos
35 Courses
13 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.9
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

Download Reverse Order Excel Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Reverse Order Excel Template

EDUCBA

डाउनलोड Reverse Order Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more