How to Swap Cells, Rows, Columns, or Ranges in Excel Office 365?
Tags: columns, kutoolsexceltutorial, kutools
Published: 2020-10-27 09:24:43

---
title: How to Swap Cells, Rows, Columns, or Ranges in Excel Office 365?
published: true
date: 2020-10-23 10:25:28 UTC
tags: columns,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-swap-cells-rows-columns-or-ranges-in-excel-office-365/
---

In this guide, we will discuss how to **Swap Cells, Rows, Columns, or Ranges in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Swap Specified Cells, Rows, Columns, or Ranges:

If you want to [swap values using macros](https://geekexcel.com/swap-values-using-macros-vba-in-excel-office-365-with-example/), check this article.

To swap specified cells, rows, columns, or ranges in the Excel spreadsheet, follow the below steps.

- You need to [open the workbook](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) which contains the data to swap. For example, we have the data table as shown in the below image, and we will swap **Column B** and **Column D**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-27.png)<figcaption id="caption-attachment-16270">Example</figcaption>

- On the **Kutools Tab, select** the **Range** option, **choose** the **Swap Ranges** option from the menu.

![Select Swap Ranges option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Swap-Ranges-option.png)<figcaption id="caption-attachment-16271">Select Swap Ranges option</figcaption>

- Now, it will open the **Swap Ranges dialog box**.
- **Swap Range 1 –** In this box, you need to select the first range using the browse button.
- **Swap Range 2 –** Here, you need to select the second input range using the given browse button.

### Note:

- The input ranges can be **cells, rows, columns,** or **specified ranges.**
- **Swap Range 1 & Swap Range 2** should contain the same number of rows and columns.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Click-the-OK-button-5.png)<figcaption id="caption-attachment-16272">Click the OK button</figcaption>

- Then, **click** the **OK** button and see that the two ranges have been swapped as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result-37.png)<figcaption id="caption-attachment-16274">Result</figcaption>

### Added Information:

- You can specify **Swap Range 1** & **Swap Range 2** across different worksheets and workbooks.
- Using this utility, you can swap entire rows and columns of your spreadsheet.

## Verdict:

In this guide, you can easily understand the steps to **Swap Cells, Rows, Columns, or Ranges in Excel Office 365** using **Kutools. ** Kindly, give your **Suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [How to Print Only Specific, Even or Odd Pages in Excel Office 365?](https://geekexcel.com/how-to-print-only-specific-even-or-odd-pages-in-excel-office-365/)
- [How to Flip Data Order of Columns or Rows in Excel Office 365?](https://geekexcel.com/how-to-flip-data-order-of-columns-or-rows-in-excel-office-365/)