If you work with several worksheets and need to find or select a certain range in all of them at once, take advantage of the Sync Selection tool. The utility is part of Ultimate Suite for Excel, a collection of 70+ handy tools for day-to-day work.
- On the Ablebits Tools tab, in the Search group, click the Sync Selection button to enable the tool:

Now, whenever you pick a range in a table, you will see the same selection in all other Excel
worksheets you switch to.
- To disable the feature, simply click on the Sync Selection button again to toggle it off.