Move around the spreadsheet

To scroll through the F1Book grid used by the spreadsheet:

  1. Use the mouse wheel to move up or down.

To move to a specific cell:

  1. Select Edit » Goto... from the main menu, enter the name of the destination cell (for example, F3), and click OK.

To use a barcode reader to move to a specific cell:

  1. Scan a sample number or a sheet command. Scanning terminates when the scanner reads the terminator code, upon which the GotBarcode (sCode As String) subroutine within the sheet barcode scan script file runs to set the Sheet and Barcode properties and display a text box in the toolbar containing the scanned content.
  2. Accept the barcode input to move to the specific cell.

To use commands to move around the spreadsheet:

  1. Click Command from the main menu.
  2. Click ... to view the list of available commands.
  3. Select the CO[L] nCol command to jump to the defined column, nCol, for the current row in the spreadsheet.
  4. Select the RO[W} nRow command to jump to the defined row, nRow, for the current column in the spreadsheet.
  5. Select the FI[ND] [/nCol] Value command to jump to the cell containing the Value, optionally only in the defined nCol column.
  6. Click the Tick to execute the command.