Range Swap Tools

In Excel, there is no easy way to reverse the order of columns/rows or swap the order of two columns or row rows. But now, you can do it very easily using Excel Power Expander.

Excel Power Expander comes with a series of “Range Swap” Tools. These are handy tools to facilitate the easy and flexible re-arrangement of the order of columns and rows. Tools in this category include:

Function Name
Description
Reverse Columns Order Reverse the order of all columns in a selected range.
(2 or more columns, single area selection)
Reverse Rows Order Reverse the order of all rows in a selected range.
(2 or more rows, single area selection)
Swap Columns Order Swap (interchange) the order of 2 columns.
(Multiple areas selection supported. i.e. can be 2 separated columns)
Swap Rows Order Swap (interchange) the order of 2 rows.
(Multiple areas selection supported. i.e. can be 2 separated rows)
Swap Columns / Rows [Form Mode] This function provides a form interface for entering the column/row numbers you want to swap. This is handy especially when the two columns/rows are far apart and you’re too lazy to use the mouse to select them.