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.

Ask a question (posted publicly)

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.
Privacy policy Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.