Resizing and Moving Explorer Pro

You can move and resize Explorer Pro using either the mouse or the keyboard.

When Explorer Pro has the focus use these keyboard shortcuts to move and resize the form:

F8 or Ctrl End - positions Explorer Pro bottom right

Ctrl-Shift-End – positions Explorer Pro bottom left

F5 or Ctrl Up Arrow or Control + (numeric keypad) – increases size of Explorer Pro

F6 or Ctrl Down Arrow or Control – (numeric keypad) – decreases size of Explorer Pro

F7 or Ctrl Home – resets Explorer Pro size and centres it on the screen

Ctrl Alt Home – resets all Explorer Pro settings and size and centres it on the screen

Using the Mouse and the Arrow keys

The 4 boxes on the form are all linked so that clicking in the Formula Box, the Expression Treeview box or the Source Reference box will select the corresponding items in the other boxes.

Clicking the Down Arrow key will select the next expression down in the Expression Treeview.

Clicking on Table2[Tax rate],"<"& C17 in the Expressions Treeview box 

The Source cells on the worksheet are selected and colored,

The criteria expression is selected in the Indented Formula and the Expression Treeview

Source Reference shows the cells the SUMIFS criteria expression is pulling from

The green text indicates that the references are source references for the function or expression.

The yellow coloring indicates that OFFSET is Volatile.

Copyright © 2020 Decision Models Ltd