[vip_students] Excel Tutorial:Lesson 8,Keystrokes to navigate the workbooks
- From: "Lists" <lists@xxxxxxxxxxxxxxx>
- To: <vip_students@xxxxxxxxxxxxx>
- Date: Mon, 19 Mar 2007 15:24:39 -0000
Introduction. As you learned in lesson one, you enter your data into a
worksheet. A worksheet is laid out as a grid, consisting of a series of
columns and rows. Gridlines mark the boundaries of the rows and columns. A
single worksheet has 256 columns and 65,536 rows.
You can use a combination of Excel and JAWS keystrokes to navigate through
cells in a worksheet and to read information about the cells. The cell that
has the focus is known as the active cell. A selection cursor appears around
the active cell.
Navigating a Worksheet. You can use a number of keystrokes to move around
the worksheet. When you select a cell, JAWS will read the cell reference,
contents, and whether the cell contains a formula.
To move one cell at a time, use the Arrow keys
To move to the first cell in the worksheet (cell A1), use Ctrl-Home.
To move to the last cell in the worksheet, use Ctrl-End.
To move to the first cell in the current row, use Home.
To move up or down one screen, press Page Up or Page Down.
To move one screen to the right or left, press Alt-Page Down or Alt-Page Up.
To move to a specific cell, use Ctrl-G to open the Go To dialog box.
Reading Keystrokes. JAWS offers a number of keystrokes to help you discern
the type and layout of data on the worksheet. The selection cursor does not
move when you use these keystrokes.
To open the Cells with Data dialog box, use Ctrl-Shift-D. This dialog box
lists every cell in the worksheet that contains data.
To open the Column Cells with Data dialog box, use Ctrl-Shift-C. This dialog
box lists all of the cells in the current column that contain data.
To open the Row Cells with Data dialog box, use Ctrl-Shift-R. This dialog
box lists all of the cells in the current row that contain data.
To read column title for the current column, use Alt-Shift-C.
To read the row title for the current row, use Alt-Shift-R.
JAWS also has four keystrokes to read the data in the first four cells of
the current column. In addition, it offers four keystrokes to read the data
in the first four cells of the current row. These keystrokes are designed to
read text labels that may appear in one of the first four cells of the
current row or column.
To read the first cell in the current column, press Alt-1.
To read the second cell in the current column, press Alt-2.
To read the third cell in the current column, press Alt-3.
To read the fourth cell in the current column, press Alt-4.
To read the first cell in the current row, press Alt-Ctrl-1.
To read the second cell in the current row, press Alt-Ctrl-2.
To read the third cell in the current row, press Alt-Ctrl-3.
To read the fourth cell in the current row, press Alt-Ctrl-4.
The following keystrokes can be helpful when you want to verify you are
entering data in the correct cell.
To read the cell reference again, use Insert-C.
To read the cell contents again, use the Numpad 5 key.
To spell the contents of the active cell, press and hold the Insert key.
Then, press the Numpad 5 key twice in rapid succession.
To determine the active worksheet and cell, press Insert-Tab.
You will use these keystrokes throughout the tutorial to determine the type
and layout of data in a worksheet. A consolidated list of keystrokes appears
in Appendix A: JAWS and Excel 2002 and 2003 Keystrokes.
Exercise Objective. In this exercise, you will use Excel and JAWS
keystrokes to navigate through a blank worksheet and obtain information
about the active cell.
Exercise: Navigating Through a Blank Worksheet
Complete the following fourteen steps to navigate through a blank worksheet.
Step 1: Press Insert-T to verify Microsoft Excel is the active program.
JAWS announces, "Title Equals Microsoft Excel - Book1."
Step 2: Press Insert-C to read the cell reference for the active cell. JAWS
should announce, "A1," indicating the selection cursor appears around the
cell at column A, row 1.
Cell A1 is the first cell in the worksheet and is currently the active cell.
Any data you type will appear in cell A1.
Step 3: Press the Down Arrow key to move the selection cursor to the next
cell in column A. JAWS announces, "Blank A2," indicating the selection
cursor is around the cell at column A, row 2.
Cell A2 is the active cell, any data you type will appear in cell A2.
Each time you move the selection cursor to a new cell, JAWS will read the
cell reference and any data that is in the cell.
Step 4: Press Insert-C to read the cell reference again. JAWS announces,
"A2."
Step 5: Press the Down Arrow key to move the selection cursor to the next
cell in column A. JAWS announces, "Blank A3," indicating the selection
cursor is around the cell at column A, row 3.
Cell A3 is the active cell, any data you type will appear in cell A3.
Step 6: Press Insert-C to read the cell reference again. JAWS announces,
"A3."
Step 7: Press the Right Arrow key to move the selection cursor to the next
cell in row 3. JAWS announces, "Blank B3," indicating the selection cursor
is around the cell at column B, row 3.
Cell B3 is the active cell, any data you type will appear in cell B3.
Step 8: Press Insert-C to read the cell reference again. JAWS announces,
"B3."
Step 9: Press the Up Arrow key to move the selection cursor to the previous
cell in column B. JAWS announces, "Blank B2," indicating the selection
cursor is around the cell at column B, row 2.
Step 10: Press the Up Arrow key to move the selection cursor to the
previous cell in column B. JAWS announces, "Blank B1," indicating the
selection cursor is around the cell at column B, row 1.
Step 11: Press the Right Arrow key to move the selection cursor to the cell
in the next column, column C. JAWS announces, "Blank C1," indicating the
selection cursor is around the cell at column C, row 1.
Step 12: Press the Right Arrow key to move the selection cursor to the cell
in the next column, column D. JAWS announces, "Blank D1," indicating the
selection cursor is around the cell at column D, row 1.
Step 13: Move through the cells on your own using the arrow keys. When you
feel you have a good idea about the cell layout, go to step 14.
Step 14: Press Ctrl-Home to move the selection cursor to the first cell in
the worksheet (cell A1). JAWS announces, "First Cell A1."
You will learn how to enter data in the next topic, "Entering Data."
What You Learned. In this topic, you learned:
The cell that has the focus is known as the active cell.
A selection cursor appears around the active cell.
Any data you enter appears in the active cell.
You can use the arrow keys to move the selection cursor to the adjacent
cell.
Excel and JAWS offer numerous keystrokes for navigating through a worksheet
and reading worksheet data. (Refer to Appendix A for a consolidated list of
keystrokes.)
Other related posts:
- » [vip_students] Excel Tutorial:Lesson 8,Keystrokes to navigate the workbooks
