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.


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 ?


Hello Ardhendu,

For us to be able to help you better, please send a small sample workbook with your source data and the result you expect to get. I kindly ask you to shorten the table to 10-20 rows.
We'll look into your task and see if our software can help.


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