Swap Ranges for Microsoft Excel
Switch columns, rows, cells in Excel 2013-2003
Swap Ranges for Excel helps you with switching the contents of two ranges. The key features of this handy tool are:
Excel – Swap columns, rows and cells in your table in seconds
Say you mistyped some data and need to swap two columns in Excel. The usual routine involves temporary ranges and much copying and pasting. The process can be even more difficult if your columns are in two different worksheets. In this case, you can lose your data or confuse the location. And what about all those references, formulas and formatting that can be broken while pasting?
The new Excel tool Swap Ranges will replace the contents of two columns, rows or cells in an instant. It will create a backup copy of your current worksheet so you don’t have to worry about losing the important details. With this helpful add-in you can also choose how to deal with the references and formatting if you have any in your table.
Switch ranges in Excel without copying and pasting
Each time you need to switch the contents of two ranges in Excel, Swap Ranges will give you a helping hand.
Start by selecting the first and the second ranges and running the tool by clicking on its icon. Choose if you want to adjust references, save them, or paste values only. See if you need to keep the formatting of the initial ranges and create a backup copy. Now just click Swap and enjoy the quick results.
When swapping columns, rows and cell data in Excel makes you waste too much time, choose Swap Ranges to improve the situation. It will modify your table, keep your data and paste them exactly as you need.
This add-in comes as part of Ultimate Suite - 50+ professional tools for Microsoft Excel
Download and try Ultimate Suite without any limitations for 14 days.
- Microsoft Excel 2016 (32- and 64-bit)
- Desktop Excel included in Office 365
- Microsoft Excel 2013 (32- and 64-bit)
- Microsoft Excel 2010 (32- and 64-bit)
- Microsoft Excel 2007
- Microsoft Excel 2003
- Windows 10 (32- and 64-bit)
- Windows 8 (32- and 64-bit)
- Windows 7 (32- and 64-bit)
- Windows Vista (32- and 64-bit)
- Windows XP (32-bit)
- Windows Server 2003, 2008, 2012
- .NET Framework 4.0 must be installed.
If you need to install the add-in for a group of users, or on a Terminal Server (servers farm) please see Corporate deployment