Moving Around in a Spreadsheet

Quattro Pro places the cell selector in cell A1 each time you start the program. You place the cell selector in a particular cell so that you can enter information into that cell. You can place the cell selector in the proper cell using either your mouse or your keyboard.

To place the cell selector in a cell using your mouse, click the cell. To place the cell selector in a cell using your keyboard, press the appropriate arrow key on the keyboard; each time you press an arrow, Quattro Pro moves the cell selector one cell in the direction of the arrow key you pressed. For example, in the blank spreadsheet that appears when you open the program, if you press the right arrow key, Quattro Pro moves the cell selector from cell A1 to cell B1. If you then press the down arrow key, Quattro Pro moves the cell selector from B1 to B2.

You also can use the vertical and horizontal scrollbars for quick navigation when the information in your spreadsheet exceeds what you can see onscreen. Click the slider box on either scroll bar and drag.

The vertical scrollbar contains two buttons with double << signs that you can click to navigate to the next and previous cells in a selected range.

Tip

If you open an existing notebook, you'll find the cell selector in the cell that was selected at the time you saved that notebook.

Using the keyboard, you have a large number of shortcuts you can take to move the cell selector efficiently. In Table 3.1, you'll find a list of the keys or combination of keys that you use most commonly to move around a spreadsheet and a description of the actions that occur when you press them.

Table 3.1. Keys to Help You Navigate a Quattro Pro Spreadsheet

Key(s)	Resulting Action
Left arrow	Moves the cell selector one cell to the left
Right arrow	Moves the cell selector one cell to the right
Up arrow	Moves the cell selector up one cell
Down arrow	Moves the cell selector down one cell
Home	Moves to cell A1
Page Up	Moves the cell selector up one screen
Page Down	Moves the cell selector down one screen
Ctrl+left arrow	Moves the cell selector left one screen
Ctrl+right arrow	Moves the cell selector right one screen
@@f5	Displays the Go To dialog box, where you specify the cell to which you want to move the cell selector. When you click OK, Quattro Pro moves the cell selector to the cell you specified.
End+Home	Moves the cell selector to the last filled-in cell in the lower-right corner of the notebook
End+arrow key	If the cell selector is in a cell containing information, this key combination moves the cell selector to the last filled cell before an empty cell in the direction of the arrow. If the cell selector is in an empty cell, this key combination moves the cell selector to the first cell containing information in the direction of the cell pointer.
Tab	In a spreadsheet, this key has the same effect as pressing the right arrow key.
Shift+Tab	In a spreadsheet, this key combination has the same effect as pressing the left arrow key.