Excel 2016 Introduction

Excel 2016

Lesson – Working with Ranges

Steps

Practice Data

4. Scroll the worksheet using the scroll bars until the cell at the bottom-right of the desired range is visible. The worksheet display scrolls accordingly. 5. Press the [Shift] key and select the cell at the bottom-right of the desired range. The desired range is selected.

Use the horizontal and vertical scroll bars to scroll cell Z100 into view

Press [Shift] and click cell Z100

Click any cell to deselect the range.

S ELECTING R ANGES WITH THE K EYBOARD  D ISCUSSION

You can select ranges with the keyboard. Keyboard selection techniques provide a very controllable way of selecting ranges of any size. Many people prefer the keyboard technique to avoid the wild-fairground-ride effect which is often experienced when selecting ranges with the mouse that extend beyond the currently visible cells.

A range can be deselected by pressing any arrow key or by clicking any cell in the worksheet.

The basic technique consists of holding down the [Shift] key while using the arrow keys on the keyboard to select the range but you can also use any of the following keys or key combinations while holding down the [Shift] key to quickly select large areas of the worksheet:

Key (with [Shift])

Effect

[Page Down]

Extends the selection one screen page down Extends the selection one screen page up Extends the selection one screen page to the right Extends the selection one screen page to the left

[Page Up]

[Alt+Page Down]

[Alt+Page Up]

OFFICEPRO, Inc.

Page 85