Home > Articles > Home & Office Computing > Other Applications

  • Print
  • + Share This
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.

  • + Share This
  • 🔖 Save To Your Account