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.
Reverse the way years are shown
So below we need to (quickly) reverse these columns so that column B is FY2010, then FY2011 etc.
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).
YouTube 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.