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 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.


Ardhendu Mishra says:
October 13, 2019 at 9:36 am

In Excel there are more than 30000 row in one column. All word are bold type in the column. But I want a particular word in the row to be normal type. Is it possible ?

Post a comment

Seen by everyone, do not publish license keys and sensitive personal info!

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