Excel 2016 Introduction

Lesson – Using Basic Workbook Skills

Excel 2016

Steps

Practice Data

2. To scroll up or down one row at a time, click the Scroll Arrow at the top or bottom of the vertical scroll bar. The display scrolls up or down one row at a time; the active cell does not change. 3. To scroll left or right one column at a time, click the Scroll Arrow at the left or right end of the horizontal scroll bar. The display scrolls left or right one column at a time; the active cell does not change. 4. To scroll quickly within the active area of the worksheet, drag the horizontal or vertical Scroll Box . The display scrolls left and right or up and down, as appropriate; the active cell does not change. 5. To scroll up and down or left and right one screen page at a time, click the space in the scroll bar between the Scroll Box and the appropriate Scroll Arrow . The display scrolls one screen page in the appropriate direction; the active cell does not change. 6. To scroll beyond the active area of the worksheet, hold down the [Shift] key and drag a Scroll Box . The display scrolls in the appropriate direction; the active cell does not change. 7. To return the top-left cell in the worksheet, press [Ctrl+Home] . The display scrolls back to the top- left corner of the worksheet and cell A1 is selected as the Active Cell.

Click the Down Arrow at the bottom of the vertical scroll bar 3 times

Click the Right Arrow at the right-hand end of the horizontal scroll bar 3 times

Drag the horizontal Scroll Box to the left end of the scroll bar

Click the space between the Scroll Box and the Down Arrow in the vertical scroll bar

Hold down the [Shift] key and drag the horizontal Scroll Box halfway along the scroll bar

Press [Ctrl+Home]

Page 40

OFFICEPRO, Inc.