How to Copy Multiple Selections in Excel Office 365?
Tags: copymultipleselectio, kutoolsexceltutorial, kutools
Published: 2020-10-17 07:30:08

---
title: How to Copy Multiple Selections in Excel Office 365?
published: true
date: 2020-10-17 07:21:05 UTC
tags: CopyMultipleSelectio,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-copy-multiple-selections-in-excel-office-365/
---

In this guide, we will discuss how to **Copy Multiple Selections 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.

## Steps to Copy Multiple Selections:

Generally, Excel won’t allow you to copy the multiple selections in your spreadsheet, and when you try to do that, it will throw an error message as shown in the below image.

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

If you really want to copy the multiple selections and paste it to anywhere in the same worksheet, then follow the below steps.

- Kutools for Excel will help you to complete this task because it has a special option of **Copy Multiple Ranges** utility.
- To do this, you need to **hold down the CTRL key** and **select** the **multiple ranges** that you want to copy.

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

- Go to the **Kutools Tab, select** the **Copy Ranges** option.

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

- It will open the **Copy Multiple Ranges Dialog box**.
- In that dialog box, you can see that the selected ranges are filled in the **Ranges to be copied** section.
- By default, it has chosen the **All option** under the **Paste special** section.
- Now, you need to **click OK** to close this dialog box.

![Copy Multiple Ranges dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Copy-Multiple-Ranges-dialog-box.png)<figcaption id="caption-attachment-15936">Copy Multiple Ranges dialog box</figcaption>

- Then, another dialog box will pop-out to ask you the location/cell reference to paste the result in the same worksheet. You need to **specify** the **cell location** using the browse button given in that dialog box.

![Select a cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-a-cell-2.png)<figcaption id="caption-attachment-15938">Select a cell</figcaption>

- At last, **hit** the **OK** button to see the result as shown in the below screenshot.

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

- Before it is impossible to copy values from the multiple cells but with the help of Kutools, you can easily achieve this! The above screenshot confirms its working!…

### Additional Info:

- You can use the **Copy Multiple Ranges** utility of **Kutools ** to copy **Formulas, Values, Formats, Displayed value, Formulas and number formats, Values and number formats,** and **Comments.**
- These options are given under the **Paste Special** section of the **Copy Multiple Ranges dialog box.**

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

## Conclusion:

From this guide, I hope you can clearly understand the steps to **Copy Multiple Selections in Excel Office 365** using **Kutools** utility. Share your **feedback** in the comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### See Also:

- [Round Cell Values without Formulas in Excel](https://geekexcel.com/how-to-round-cell-values-without-formulas-in-excel-office-365/)
- [Convert Between Roman Numerals and Numbers in Excel Office 365!!](https://geekexcel.com/convert-between-roman-numerals-and-numbers-in-excel-office-365/)