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.

Please contact us here

Our working hours:
Pacific Time (PT) 11:00 PM (previous day) – 2:00 PM
Central European Time (CET) 08:00 - 23:00
Eastern Time (ET) 2:00 AM – 5:00 PM
Central Time (CT) 1:00 AM – 4:00 PM
Pacific Time (PT) 11:00 PM (previous day) – 2:00 PM
Australian Eastern Daylight Time (AEDT) 6:00 PM – 9:00 AM (next day)
If you want to attach files (e.g. screenshots or log files), it will be possible right after you send this form and we automatically create a support ticket for you.