Filter the list of watch variables

You can filter the Watch list using the icon. This filter dialog supports searching the Name and Formula fields.

Once you have filtered the list, click the icon to remove the filtered-out items from the Watch Set. Alternatively, right click on the list and choose Remove Filtered items from the context menu.

You can only move the order of watch items in the list when the list is not sorted or filtered. Watch item order depends on their index relative to their neighbors and sorting and filtering temporarily changes this. If this list is sorted or filtered, you must clear this before the items can be ordered.

To clear any sorting, right-click on the header and select Clear Sorting; to clear any filtering, right-click on an item in the watch set and select Remove Filtered Items.

Warning: The order of watch items is important. Items can be sorted and grouped within the Watch window, but when the watch set is accessed via the Excel Add-In, the items appear in Excel in the same order as they appear in the watch set. Thus if you've used formula linking in Excel, and then change the order of watch items, the formula links in Excel will no longer be valid, which will lead to potentially unexpected behavior if using Excel to publish results.