Easily Swap Cells, Rows, Columns or Ranges in Excel

Click Kutools >> Range >> Swap Ranges. See screenshots:

Usage:

1. Apply this utility by clicking Kutools > Range> Swap Ranges;
2. Please specify Swap Range 1 and Swap Range 2 in Swap Ranges dialog box. Note: Swap Range 1 and Swap Range 2 must contain the same number of both rows and columns.
3. Click OK. And the two ranges have been swapped. See screenshots:

Notes:

1. When swapping ranges with formulas, it will pop out below screenshot to remind you and ask for your operation: convert the formula to value and continue, reverse the formula reference to continue, or cancel.
   
2. It can swap entire rows or columns.
3. You can specify Swap Range 1 and Swap Range 2 across different worksheets and workbooks.
4. This operation supports Undo. If the result is not what you want, you can press Undo (Ctrl +Z) immediately to restore it.
5. Swap Range 1 and Swap Range 2 must contain the same number of both rows and columns.

Demo: Swap Cells, Rows, Columns or Ranges in Excel

Productivity Tools Recommended

Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...

Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...

---

Kutools for Excel

Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.

🌍 Supports 40+ interface languages

✅ Trusted by 500,000+ users and 80,000+ businesses worldwide

🚀 Compatible with all modern Excel versions

🎁 30-day full-featured trial — no registration, no limitations

Try It Now!See PricingUnlock Full Features