Excel 2016 Introduction

Excel 2016

Lesson – Using Basic Workbook Skills

left of the screen. You can also click in the blank area of the scroll bar between the Scroll Box and a Scroll Arrow to scroll up, down, left or right one screen page at a time.

NOTE If you hold down the [Shift] key while dragging a Scroll Box , you can scroll through the entire worksheet area.

P ROCEDURES 1. To change the Active Cell , click on the cell that you wish to make active. 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. 3. To scroll left or right one column at a time, click the Scroll Arrow at the left end or right end of the horizontal scroll bar. 4. To scroll quickly within the used area of the worksheet, drag the horizontal or Scroll Box . 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 . 6. To scroll beyond the utilized area of the worksheet, hold down the [Shift] key and drag a Scroll Box , or click and hold the appropriate Scroll Arrow . 7. To return the top-left cell in the worksheet, press [Ctrl+Home] .  S TEP - BY -S TEP From the Student Data directory, open DISTRICT.XLSX . Scroll through a worksheet using the mouse. vertical

Steps

Practice Data

1. To change the Active Cell , click on the cell that you wish to make active. The selected cell becomes the active cell, a heavy border is displayed around the cell and the appropriate column and row heading are highlighted.

Click cell D7

OFFICEPRO, Inc.

Page 39