Filtering Result Cells

Clicking the Filter button (or shortcut Key Alt-J) toggles on/off showing the Filtered Results box.

Filtering Array Results

When an expression returns an error value it is shown in red.

To find out which cells in a large range are causing the error you can:

1.Click the Filter button to show the results box.

2.Choose the Errors filter from the filter drop-down

3.The Results box shows the rows with errors, colors them and selects them

Getting more Information with Tooltips

When you hover over an item an explanatory tooltip will appear.

Or you can change an Explorer Pro setting so that all the tooltips appear as additional TreeView Nodes.