Excel 2016 Introduction

Excel 2016

Lesson – Working with Ranges

NOTE You can also use the keyboard to select non-adjacent ranges. Select the first contiguous block of cells in the normal way. Press [Shift+F8] to activate Add to Selection mode. An indicator appears in the Status Bar . Use the arrow keys to move to the beginning of the next block of cells you wish to select. Hold down the [Shift] key and select the additional block using the arrow keys or [Page Up] , [Page Down] , [Ctrl+Home] , etc. Release the [Shift] key. Add to Selection mode turns off automatically. To select additional blocks of cells, press [Shift+F8] again.



P ROCEDURES

1. Drag to select the first contiguous block of cells. 2. Release the mouse button. 3. Hold [Ctrl] and drag to select another contiguous block of cells. 4. Release the mouse button. 5. Repeat steps 3 and 4 to add additional blocks of cells to the range, as desired. 6. Release the [Ctrl] key.



S TEP - BY -S TEP

Select non-adjacent ranges.

Steps

Practice Data

1. Drag to select the first contiguous block of cells. The range is highlighted as you drag.

Select cells A4 to cell A8

2. Release the mouse button. The range is selected.

Release the mouse button

3. Hold [Ctrl] and drag to select

Hold [Ctrl] and drag from cell C5 to cell C8

another contiguous block of cells. The range is highlighted as you drag.

4. Release the mouse button.

Release the mouse button

The additional range is selected

5. Release the [Ctrl] key.

Release [Ctrl]

The two separate areas are selected as a range.

OFFICEPRO, Inc.

Page 89