- Selecting Cells
- Moving Around in a Spreadsheet
- Moving to a Different Spreadsheet
- Entering Information
- Correcting Mistakes
- Saving a Notebook
This chapter is from the book
This chapter is from the book
This chapter is from the book
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.
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. |