Swap Ranges for Microsoft Excel

Switch columns, rows, cells in Excel 2016 - 2007

Swap Ranges for Excel helps you with switching the contents of two ranges. The key features of this handy tool are:

  • Swap columns, rows, cells in Excel and adjust or keep cell references
  • Swap ranges and paste values only
  • Easily switch data between 2 workbooks
  • Keep the formatting of your cells and automatically get a backup copy

Free download for:

Use the Swap Ranges tool to switch columns, rows and cells in Excel

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.

Swap Ranges will instantly switch the contents of two ranges

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 - 60+ professional tools for Microsoft Excel

Download and try Ultimate Suite without any limitations for 14 days.

Free Download
Free 14-day trial version, 13 MB

System requirements:

Microsoft Excel

  • 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

Operating System

  • 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

Featured customers

Ablebits.com featured customers
Contact us
  Publish your message on our support forum

Our working hours: 0am to 10am PST; 3am to 1pm EST; 8am to 6pm CET.

Excel add-ins and Outlook tools - Ablebits.com