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.
- On the Ablebits Tools tab, in the Search group, click the Sync Selection button to enable the tool:
Now, whenever you pick a range in a table, you will see the same selection in all other Excel worksheets you switch to. - To disable the feature, simply click on the Sync Selection button again to toggle it off.
Responses
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 support@ablebits.com.
