Excel 2016 Introduction

Lesson – Using Basic Workbook Skills

Excel 2016

6. Select the desired command.



S TEP - BY -S TEP Use the scroll bar shortcut menu.

Steps

Practice Data

1. To scroll to a relative position within the utilized worksheet area, right-click on the desired

Right-click the mid-point of the vertical scroll bar

position in either scroll bar. A shortcut menu appears.

2. Select Scroll Here .

Click Scroll Here

The shortcut menu closes and the worksheet scrolls to the corresponding position.

3. To scroll vertically, right-click

Right-click anywhere in the vertical scroll bar

anywhere in the vertical scroll bar. A shortcut menu appears.

4. Select the desired command.

Click Page Down

The shortcut menu closes and the worksheet scrolls accordingly.

5. To scroll horizontally, right-click anywhere in the horizontal scroll bar. A shortcut menu appears.

Right-click anywhere in the horizontal scroll bar

6. Select the desired command.

Click Page Right

The shortcut menu closes and the worksheet scrolls accordingly.

Practice the Concept: Right-click in the horizontal scroll bar and select the Left Edge command. Notice that the worksheet scrolls to display column A . Right-click in the vertical scroll bar and select the Top command. Notice that the worksheet scrolls to display row 1 .

U SING THE G O T O D IALOG B OX  D ISCUSSION

In addition to using the mouse to select a different active cell, you can use the Go To dialog box. You specify the cell you want to select and Excel activates and displays that cell. This is especially

Page 42

OFFICEPRO, Inc.