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 9am PST; 3am to 12am EST; 9am to 6pm CET.

Ultimate Suite for Excel Professionals
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Sheila Blanchard
Excel add-ins and Outlook tools - Ablebits.com