To position the caret at a specific place in your document, you move the pointer to the cell required and click there. Note that if the cell you are pointing at is a blank cell and there is a text cell to the left, PipeDream will place the caret in the text cell. It does this to prevent you accidentally typing text into the wrong column. If you really want to be in the cell you are pointing at and not the text cell, press and hold down Ctrl and click in the cell.
You can also use the keyboard to move around the document.
Press the ↑ (up arrow) or ↓ (down arrow) keys to move up or down a line at a time. PipeDream will scroll the window if necessary.
Press the ← (left arrow) key to move the caret one character to the left, or to the previous column.
Press the → (right arrow) key to move the caret one character to the right.
Press Shift- → to move the caret to the next word.
Press Shift- ← to move the caret to the previous word.
Press Ctrl- → to move the caret to the end of the cell.
Press Ctrl- ← to move the caret to the start of the cell.
Press Tab to move to the next column.
Press Shift-Tab to move to the previous column.
Press Home to go to the top of the column.
Press End to go to the bottom of the column.
Press Page Up or Page Down to move a windowful down or up at a time.
Press Cmd-CPL or Cmd-CPR to move a windowful left or right. It may be easier to do this by clicking in the horizontal scroll bar.
Note that ← is the left arrow key and should not be confused with ↤ (Backspace) which deletes the character to the left of the caret.
Give the First Column command to move to the first column or the Last Column command to move to the last column.
Menu | Command | Tool | Key | Cmd-sequence |
---|---|---|---|---|
Caret | First column | Ctrl-Shift-Tab | CFC | |
Last column | Ctrl-Tab | CLC |
Give the Go to Cell command
Menu | Command | Tool | Key | Cmd-sequence |
---|---|---|---|---|
Caret | Go to Cell | CGS |
When the dialogue box appears, type in the reference of the cell you want to move to.
The cell reference can be an external reference to a cell in another document.
In this case, type in the cell reference as [document]cell_reference
, where document is the name of the document you want to move to.
For example, if you type [letter]A3, the caret will be positioned in cell A3 of the document called ‘letter’.
That document’s window will come to the front of the screen.
The Centre Window command puts the line with the caret on it in the centre of the window:
Menu | Command | Tool | Key | Cmd-sequence |
---|---|---|---|---|
Caret | Centre Window | CWI |
PipeDream has three commands which help you switch between two parts of a document very quickly.
You can tell PipeDream to remember (‘save’) the current position. Then, from another part of the document, you can jump back to this position in one of two ways:
Using the latter method, you can jump backwards and forwards between the two positions simply by giving the command.
Menu | Command | Tool | Key | Cmd-sequence |
---|---|---|---|---|
Caret | Save Position | CSP |
Menu | Command | Tool | Key | Cmd-sequence |
---|---|---|---|---|
Caret | Restore Position | CRP |
The caret will move back to the position you saved. If the restored caret position is in another document, that document’s window will come to the front of the screen. This command is especially useful if you are working on a very large document.
The Swap Position and Caret command enables you to move between the last saved position and the caret position:
Menu | Command | Tool | Key | Cmd-sequence |
---|---|---|---|---|
Caret | Swap Position and Caret | CWC |