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.

  1. On the Ablebits Tools tab, in the Search group, click the Sync Selection button to enable the tool:
    Enable Sync Selection.
    Now, whenever you pick a range in a table, you will see the same selection in all other Excel worksheets you switch to.
  2. To disable the feature, simply click on the Sync Selection button again to toggle it off.