Synchronous select same cells in all worksheets of Excel
Kutools for Excel
Boosts Excel With 300+
If you want to force all worksheets of the active workbook to have the same selected range and upper left cell for viewing or editing the content of all worksheets in the same position, you may have to separately scroll each worksheet to the same position you want. Kutools for Excel's Sync Worksheets utility can easily select the same range or cells in all worksheets.
Click Kutools Plus >> Worksheet >> Sync Worksheets. See screenshot:
1. Active a workbook and select a range that you want to use. In this example, I will select range A1:D7 of the current worksheet first, and then apply this utility by clicking Kutools Plus > Worksheet > Sync Worksheets.
2. And then when you navigating between all worksheets, each worksheet will have the same range being selected as shown in the below screenshots.
Note: This feature does not support all hidden worksheets, which will be automatically ignored.
Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. Download and free trial Now!
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.
The functionality described above is just one of 300 powerful functions of Kutools for Excel.
Designed for Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 30 days.