General Settings

Explorer Pro HotKey

Use Ctrl HotKey or Ctrl-Shift Hotkey to start or refresh Explorer Pro. The default is M, so Ctrl-m or Ctrl-Shift-M will start or refresh Explorer Pro. If you change the hotkey it must be a single character.

Smart Indent

Smart Indent recognises the function being used and adjusts the indentation accordingly the next time you refresh or reformat the formula.

Initial Indent Style

This is a number from 1 (no indents or new lines) to 7 (maximum indentation and new lines) that controls the Indent style to be used the next time you start Explorer Pro.
The initial default setting is 3. When Explorer Pro has the focus you can use F5 to increase the indentation style and F6 to decrease the indentation style.

Indent Styles

1 – No Indentation

2 – New line for each Function or smart indent

3 – New line on change of parenthesis level or before Function or smart indent

4 – New line on change of parenthesis level or before Function or after first function parameter or smart indent

5 – New line on change of parenthesis level or before Function( and after Function(

6 - New line on change of parenthesis level or before Function( and after Function( and after each separator

7 - New line on change of parenthesis level or before Function( and after Function( and after each operator or separator

Auto DPI Resize

When this is checked the size of the Formula Explorer Form and the Font size will be increased if the main screen uses a high DPI setting.

Font Size

You can change the font size used in the 4 display boxes. The default is 9 for Windows and 10 for Mac.

Show Formulas in Local Language

If you uncheck this option Explorer Pro will show formulas using English function names and separators. 91 languages are supported for localised function names.

GoTo Settings

Go To Selected Reference

If checked then when a reference is clicked in Explorer Pro its cell(s) will be selected. See also Precedent Coloring.

Unhide Hidden GoTos

If checked and the GoTo range is hidden it will be unhidden.

Scroll GoTo

If checked all GoTo actions will scroll to the selected range.

Smart Scroll Userform
If the GoTo range is hidden by Explorer Pro an attempt will be made to move Explorer Pro to unhide the GoTo reference.

Return to Home Cell on Close

When Explorer Pro is closed the Excel Window will scroll to the Home cell.

Stop Go To from triggering Events

When checked, Events such as Selection Change will not be triggered by a GoTo initiated by clicking on an expression, Precedent or Dependent in Formula Explorer.

Edit Mode Array Formula Handling:

These settings control whether or not the formula is entered back into the destination cell as an array formula.

The default is that if the formula was originally an array formula then it will be entered as an array formula. The other options allow you to convert an array formula to a non-array formula and vice versa.

Copyright © 2020 Decision Models Ltd