Synchronously select same cells in all worksheets of Excel 2007/2010
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. Now, Kutools for Excel’s Synchronize Worksheets can easily get it done with one click, making each worksheet has: Demo
- The same range selection
- The same upper left cell
Click "Kutools">>"Worksheets tools">>"Synchronize Worksheets". See screenshots (Fig. 1 and Fig.2).
 |
 |
 |
| Fig. 1 Synchronize Worksheets |
Fig. 2 After Synchronize Worksheets |
Usage:
- Active a worksheet and select a cell or range;
- Click Synchronize Worksheets;
- Click OK.
Notes:
- This feature does not support all hidden worksheets, which will be automatically ignored.
- It will pop up a dialogue box telling you how many worksheets have been synchronized.
See Synchronize Worksheets feature demo (video 1)
Video 1.Synchronize Worksheets feature demo.
This is only one feature of Kutools for Excel
It includes more than 100 functions and tools for Excel 2007 and 2010.
