Excel 2016 Introduction

Excel 2016

Lesson – Using Basic Workbook Skills

Practice the Concept: Press [Page Down] two times to scroll down two screens and reposition the active cell. Drag the Scroll Box to the top of the vertical scroll bar. Notice that the display scrolls to row 1. Notice that the Name Box to the left of the formula bar shows that the active cell has not changed position. Click cell A1 to select it. Notice that the Name Box now shows A1.

U SING THE S CROLL B AR S HORTCUT M ENU  D ISCUSSION

Shortcut menus are available on the horizontal and vertical scroll bars that provide options for scrolling one row or column at a time or one screen page at a time. In addition, the Top and Bottom commands on the vertical scroll bar shortcut menu let you quickly scroll to the top or bottom of the utilized worksheet area. Likewise, the Left Edge and Right Edge commands on the horizontal scroll bar shortcut menu let you quickly scroll to the left or right edge of the utilized worksheet area.

Using the scroll bar shortcut menu

NOTE The Scroll Here command on both shortcut menus lets you quickly scroll to a relative position within the utilized area of the worksheet. Right-clicking halfway down the vertical scroll bar and selecting Scroll Here from the shortcut menu, scrolls the display to a position halfway down the utilized area of the worksheet.



P ROCEDURES 1. To scroll to a relative position within the utilized worksheet area, right-click on the desired position in either scroll bar. 2. Select Scroll Here . 3. To scroll vertically, right-click anywhere in the vertical scroll bar. 4. Select the desired command. 5. To scroll horizontally, right-click anywhere in the horizontal scroll bar.

OFFICEPRO, Inc.

Page 41