How to keep the same selection in Excel sheets

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 60+ handy tools for day-to-day work.

  1. Enable the Sync Selection toggle button by clicking it in the Search group on the Ablebits Data tab:
    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.