Invert/ Reverse COLUMNS in Excel

A recent request is whether there is a (quick) way to invert/ reverse columns in Excel? For example change a table that runs from FY2014 to FY2010 to FY2010 to FY2014.

YouTube Invert/ Reverse COLUMNS in Excel

Reverse the way years are shown

So below we need to (quickly) reverse these columns so that column B is FY2010, then FY2011 etc.

Invert/ Reverse COLUMNS in Excel

Manually doing this will take too long. The easiest way will be to sort the columns and you can do this with the normal Data Sort tool in excel.

As shown below:

  • Highlight the area that needs to be sorted
  • Click on the DATA ribbon and choose the SORT button
  • Click on OPTIONS
  • Choose to Sort Left to Right
  • Tell it which row to sort by (row 3 in this case) and in what direction (A to Z or Z to A).
Invert/ Reverse COLUMNS in Excel

Want to learn more about Microsoft Excel? If you prefer attending a course and live in South Africa look at the Johannesburg MS Excel 3 Day Advanced Course  or the Cape Town MS Excel 3 Day Advanced training course. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.

Reverse Data in Excel

Fixing date format or sort issues in Excel

Undo sort in Excel

How to insert a row between each row in Excel