Cell Selection Mode

The most convenient method for inserting relative and absolute cell references is to use cell selection mode. In cell selection mode, cell references are created by clicking cells directly in the spreadsheet; providing a means to visually select a cell, rather than having to remember if the Blob count was contained in cell G67 or cell D25, for example.

Invoking Cell Selection Mode

The spreadsheet enters Cell Selection Mode when the user selects either Relative Reference or Absolute Reference through an Insert menu or toolbar buttons.

When in cell selection mode, the display temporarily switches into a unique view of the In-Sight spreadsheet where the image is not visible beneath the spreadsheet and an expandable rectangle with a red outline represents the cell(s) to be referenced while the destination cell is a solid pink color.

Establishing a Cell Reference

1. Choose the cell(s) to reference. One or more cells may be selected with either the mouse or the keyboard. To select multiple cells with the mouse, click and drag across any cells to reference. Using the keyboard, hold down SHIFT and press the ARROW KEYS to select a group of cells.
2. Accept the reference. References may be accepted either by double-clicking the desired cell (for a single-cell reference) or by pressing ENTER (for referencing either single or multiple cells). Once the reference has been accepted, the display switches back to the property sheet, dialog, or spreadsheet cell from which cell selection mode was initiated.