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

Note: kutools for Excel 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

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

Select Sync Worksheets option

• 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

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

Output

Additional Info:

• The Sync Worksheets option doesn’t support all the hidden worksheets.
• 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. Keep Learning!

Read Ahead:

• Insert Multiple Checkboxes at Once in Excel Office 365!!
• Unprotect Multiple Worksheets at Once in Excel Office 365!!