Synchronous Select Same Cells in All Worksheets of Excel Office 365!!
Tags: kutoolsexceltutorial, selectsamecellsinall, kutools
Published: 2020-10-22 12:16:17

---
title: Synchronous Select Same Cells in All Worksheets of Excel Office 365!!
published: true
date: 2020-10-22 07:04:12 UTC
tags: KutoolsExcelTutorial,SelectSameCellsinAll,Kutools
canonical_url: https://geekexcel.com/synchronous-select-same-cells-in-all-worksheets-of-excel-office-365/
---

Here, we come up with the instructions for **Synchronous Select Same Cells in All Worksheets of 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.
## Select Same Cells in All Worksheets:

To select the same range of cells in all sheets, follow the below steps.

- **Synchronous select** the **same cell** means if you **select a specific range** of cells on **sheet 1** , and then it will **select the same range of cells** in all the **remaining sheets** in the same workbook.
- Firstly, you need to activate the workbook and select the range that you want to select in all the sheets.
- Here, we have **selected the range B2:E5** as shown in the below screenshot.

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

- Go to the **Kutools Plus Tab, select** the **Worksheet** option, **choose** the **Sync Worksheets** option from the menu.

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

- Now, a prompt box will pop-out to tell you that all the worksheets have the same selection range. Refer to the below image.

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

- Then, if you move between all the worksheets, each worksheet will have the same selection range as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-scaled.jpg)<figcaption id="caption-attachment-16214">Output</figcaption>

### Additional Info:

- The Sync Worksheets option doesn’t support all the [hidden worksheets](https://geekexcel.com/how-to-hide-a-worksheet-in-microsoft-excel-365/).
- It can ignore them automatically.

## Sum-Up:

From this article, you can easily learn the instructions for **Synchronous Select Same Cells in All Worksheets of Excel Office 365** using **Kutools. ** Kindly, give your **suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [Insert Multiple Checkboxes at Once in Excel Office 365!!](https://geekexcel.com/insert-multiple-checkboxes-at-once-in-excel-office-365/)
- [Unprotect Multiple Worksheets at Once in Excel Office 365!!](https://geekexcel.com/unprotect-multiple-worksheets-at-once-in-excel-office-365/)