How to Select, Deselect, and Reverse Multiple Ranges in Excel 365?
Tags: kutoolsexceltutorial, selectdeselectrevers, kutools
Published: 2020-11-20 09:53:12

---
title: How to Select, Deselect, and Reverse Multiple Ranges in Excel 365?
published: true
date: 2020-11-20 05:08:55 UTC
tags: KutoolsExcelTutorial,SelectDeselectRevers,Kutools
canonical_url: https://geekexcel.com/how-to-select-deselect-and-reverse-multiple-ranges-in-excel-365/
---

In this article, we are going to see how to **Select, Deselect, and Reverse Multiple Ranges in Excel Office 365** using **Kutools.** Let’s get into this article!! 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.
## Select Multiple Non-Adjacent Ranges in Any Worksheet:

To select multiple ranges without using **CTRL Key** in the same worksheet or multiple worksheets, do as below steps.

- First, you need to **activate the worksheet** where you need to select the ranges.
- Here, we are going to **select ranges in two sheets** they are **Sheet 1** and **Sheet 2**.

![Sheet 1 and Sheet 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/image.jpg)<figcaption id="caption-attachment-17687">Sheet 1 and Sheet 2</figcaption>

- To do this, go to the **Kutools Tab, click** the **Select** option, then **choose** the **Select Range Helper** option.

![Select the Select Range Helper option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-32.png)<figcaption id="caption-attachment-17683">Select the Select Range Helper option</figcaption>

- It will display the **Select Range Helper Dialog box**.
- **Select –** In this section, you need to **check** the **Union Selection** option.

![Select the Union Selection option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Union-Selection-option.png)<figcaption id="caption-attachment-17688">Select the Union Selection option</figcaption>

- Now, you can select the range easily.

### Selected Ranges in Sheet 1:

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

### Selected Ranges in Sheet 2:

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

## Deselect Cells from a Selected Range:

If you have a selected range in your worksheet and you need to deselect some cells from the selected range, then do as follows.

- Let’s consider an **example worksheet** given below, where you can see the **selected range**.

![Selected range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-31.png)<figcaption id="caption-attachment-17694">Selected range</figcaption>

-  On the **Kutools Tab, click** on the **Select** option, then **choose** the  **Select Range Helper** option.

![Select the Select Range Helper option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-32.png)<figcaption id="caption-attachment-17683">Select the Select Range Helper option</figcaption>

- It will display the **Select Range Helper Dialog box**.
- **Select –** In this section, you need to **check** the **Deselect Cells** option.

![Select Range Helper Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-30.png)<figcaption id="caption-attachment-17695">Select Range Helper Dialog box</figcaption>

- Now, you can deselect cells from the range as shown in the below image.

![Deselected cells](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-26.png)<figcaption id="caption-attachment-17696">Deselected cells</figcaption>

## Reverse Selected Ranges:

You can use the **Inverse Selection** option to select the reverse range in the worksheet. To do this, follow the below steps.

- The below screenshot has shown the worksheet with the selected range. We are going to **select** the **reverse range** in the worksheet.

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

- Go to the **Kutools Tab, click** the **Select** option, then **choose** the **Select Range Helper** option.

![Select the Select Range Helper option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-32.png)<figcaption id="caption-attachment-17683">Select the Select Range Helper option</figcaption>

- It will open the **Select Range Helper Dialog box**.
- **Select –** Here, you need to **check** the **Inverse Selection**  option.

![Select Range Helper Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-21.png)<figcaption id="caption-attachment-17698">Select Range Helper Dialog box</figcaption>

- Now, you can **select the range in reverse order** as shown in the below image.

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

## Verdict:

In the above article, you can easily understand the steps to **Select, Deselect, and Reverse Multiple Ranges in Excel Office 365** using **Kutools. ** Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Related Articles:

- [How to Find the Sum of All Digits/Numbers in a Cell in Excel Office 365?](https://geekexcel.com/how-to-find-sum-of-all-digits-numbers-in-a-cell-in-excel-office-365/)
- [How to Change Case of Text to All Caps, Lower and Proper in Excel 365?](https://geekexcel.com/wp-admin/post.php?post=17518&action=edit)