Microsoft Office Tutorials and References
In Depth Information
Navigating Within a Worksheet
Navigating Within a Worksheet
Each cell within a worksheet is identifi ed by a cell reference , which indicates its column
and row location. For example, the cell reference B6 refers to the cell located where
column B intersects row 6. The column letter always appears before the row number in any
cell reference. Row numbers range from 1 to 1,048,576. The fi rst 26 column letters range
in alphabetical order from A to Z. After Z, the next column headings are labeled AA, AB,
AC, and so forth. Excel allows a maximum of 16,385 columns in a worksheet (the last
column has the heading XFD). When Excel starts, cell A1 is the active cell.
As you work, you’ll need to change which cell is the active cell. You can use your
mouse to click a cell to make it the active cell, or you can use the keyboard to move
between cells, as described in Figure 1-2.
Figure 1-2
Excel navigation keys
Press
To move the active cell
Up, down, left, or right one cell
Home
To column A of the current row
Ctrl+Home
To cell A1
Ctrl+End
To the last cell in the worksheet that contains data
Enter
Down one row or to the start of the next row of data
Shift+Enter
Up one row
Tab
One column to the right
Shift+Tab
One column to the left
Page Up, Page Down
Up or down one screen
Ctrl+Page Up, Ctrl+Page Down
To the previous or next sheet in the workbook
You’ll use both your mouse and your keyboard to change the active cell in the Sheet1
worksheet.
To change the active cell:
1. Move your pointer over cell , and then click the mouse button. The active cell A5
moves from cell A1 to cell A5, and the cell reference in the Name box changes
from A1 to A5. The column heading for column A and the row heading for row 5
are both highlighted.
2. Press the
key on your keyboard. The active cell moves one cell to the right to
cell B5.
3. Press the Page Down key. The active cell moves down one full screen.
4. Press the Page Up key. The active cell moves up one full screen, back to cell B5.
5. Press the Ctrl+Home keys. The active cell returns to the first cell in the worksheet,
cell A1.
The mouse and keyboard provide quick ways to navigate the active worksheet. For
larger worksheets that span several screens, you can move directly to a specifi c cell
using the Go To dialog box or by typing a cell reference in the Name box. You’ll try both
of these methods.
 
Search JabSto ::




Custom Search