When Explorer Pro has the Focus

Mouse Click

Left-click selects an expression or clicks a command button

Shift-Click or Right-Click (only on Windows) on an expression drills down to that expression. Drill-down selects that expression and refreshes Explorer Pro using the contents of the selected reference, but does not change the Home cell.

Ctrl key combinations for moving and resizing Explorer Pro:

Ctrl-Home                     Recentres Explorer Pro and resets size

Ctrl-End                    Moves Explorer Pro to bottom right

Ctrl-Shift-End                    Moves Explorer Pro to bottom left

Ctrl Up arrow or Ctrl numeric keypad +          Increases size

Ctrl Down arrow or Ctrl numeric keypad - Decreases size

Ctrl Alt Home                    Resets the form and all its settings

Undo/Redo/Forward/Back

Right Arrow

oView Mode: Next drill-down step

oDebug Mode: Next Debug Step

oEdit Mode: Redo last Edit

Left Arrow

oView Mode: Previous drill-down step

oDebug Mode: Previous Debug Step

oEdit Mode: Undo last Edit

Alt Delete                    Clears the Drill-Down,  GoTo and Undo stacks

Navigating the Treeview with the Arrow keys

Up Arrow  – move selection up an expression

Down Arrow– move selection down an expression

Expanding/Contracting the Treeview

+ Icon                    Expand this Node in the Tree

- Icon                    Contract this Node in the Tree

Alt Up                     Collapse TreeView to Home node

Alt Down           Expand all Expression nodes

Alt Right           Expand the TreeView one level

Alt Left                     Contract the TreeView one level

Shift any Arrow key   Expand/Contract the active expression node

Accelerator Alt Keys (Cmd Key on Mac) for the Command Buttons

Alt-B                    Back/Undo

Alt-D                    Debug Mode

Alt-E                    Edit Mode

Alt-F                    Refresh Explorer Pro Formula from the current active cell

Alt-Ctrl-F          Refresh Explorer Pro with Conditional Format from active cell

Alt-Ctrl-Shift-F          Refresh Explorer Pro with Data Validation from active cell

Alt-H                    Goto Home cell and refresh

Alt-I                    Toggles Indent on off/on

Alt-J                    Toggles Color Precedents and show array results on/off

Alt-N                    Next or Redo

Alt-P                    Prints an A4 snapshot of the form

Alt-R                    Toggle Expressions/Precedents

Alt-Q                    Toggle Expressions/Dependents

Alt-S                    Settings

Alt-T                    Filter On/Off

Alt-V                    View Mode

Function Keys

F1                     Help

F3                     Manage Names or Insert Name in Edit Mode

F4                     Toggles relative and absolute (Edit mode)

F5                     Increases Indentation step-by-step

F6                     Decreases Indentation step-by-step

F7                     Resets Indentation to default

Store the Indented Formula in the Home cell(s)

Alt-Enter          The indented version of the formula from the formula box will replace the formula in the Home cells.

Copyright © 2019 Decision Models Ltd