Lesson 11

Preview

Basic Navigation in an Excel Worksheet

Figure 1 – Navigation Keys for Excel

Worksheet Navigation is accomplished by selecting one of a set of navigation keys on a keyboard or usage of a mouse. Desktop PCs contain a set of 4 navigation arows and many laptops do as well. The graphic above in FIGURE 1 shows 4 navigation keys. Although this photo was taken from a laptop keyboard, the same 4 navigation keys are displayed similarly on a desktop PC. Depressing one of these 4 keys will move the active cell to the next adjacent cell in the direction of the key’s arrow display. The “Enter” key, when depressed, will move the active cell down into the cell adjacent to the active. The “Tab” key, when depressed, will move the active cell to the next adjacent cell on the right.

Although these keys described above certainly work well for navigation, you may find that using the mouse to select the cell you wish to navigate to is often more convenient.


Worksheet Navigation Keys Information

To move the active cellDo one of the following
RightTab, right arrow, mouse, *Enter key (dependent on options choice)
LeftShift+Tab, left arrow, mouse, *Enter key (dependent on options choice)
DownEnter, down arrow, mouse, *Enter key (dependent on options choice)
UpUp arrow, mouse, *Enter key (dependent on options choice)
*Must go into Excel Options Advanced section, Editing options, to change the action of the active cell after depressing the Enter key.


Practice Exercise 1: Perform various methods of navigation through the various cells, rows, and columns of a worksheet.

STEP 1: Ensure cell A1 is the active cell (FIGURE 1). The active cell is the cell with the dark border. The active cell is used to enter data into a worksheet. Notice that A1 is in the Name Box above.

Figure 1

STEP 2: ​Make A2 the active cell by pressing the Enter key (FIGURE 2). Note that pressing the Enter key moves the active cell down to the next row. Notice that A2 is in the Name Box above.

Figure 2

​STEP 3: Make cell A1 the active cell by pressing the Up arrow key (FIGURE 3).

The Up arrow key is the top key of a 4-key group of keys on the keyboard and is situated next to the numeric keypad.

Figure 3

STEP 4: Press F5 to open the Go To dialog box (FIGURE 4).

STEP 5A: In the Reference section, enter AAA156.

Press OK button.

Figure 4

Observe that the active cell is AAA156 (FIGURE 5). 

Figure 5

​STEP 5B: Press the CTRL + Home key to return the active cell to A1. Cell A1 is now the active cell (FIGURE 6).

Figure 6

STEP 6A: Locate the vertical scroll bar and arrows (FIGURE 7). Click on the downward pointing vertical scroll arrow and scroll the screen.


STEP 6B Locate the horizontal scroll bar and arrows (FIGURE 8). Click on the rightward pointing horizontal scroll arrow and scroll the screen.

Figure 8

END OF LESSON


Back to: Intro to Excel 2016 > Module 4 Intro to Excel 2016

Leave a Reply