Excel 2016 Introduction

Lesson – Working with Ranges

Excel 2016



P ROCEDURES

1. Select the cell containing the entry you wish to extend into a series. 2. Point to the fill handle at the bottom right corner of the active cell. 3. Drag the fill handle to select the range you want to fill. 4. Release the mouse button. 5. Click the Auto Fill Options button . 6. Select the desired Auto Fill option.



S TEP - BY -S TEP Use the Auto Fill feature to create a label series.

Enter Jan in cell C4 and press [Enter] .

Steps

Practice Data

1. Enter starting data into a cell.

Enter Jan into cell C4

2. Select the cell containing the entry you wish to extend into a series. The cell becomes the Active Cell . 3. Point to the fill handle at the bottom right corner of the active cell. The mouse pointer changes to a solid, black plus sign (+). 4. Drag the fill handle to select the range you want to fill. An outline of the range appears as you drag and a ScreenTip appears, for each cell in turn, showing the entry that will appear in each cell.

Click cell C4

Point to the fill handle at the bottom right corner of cell C4

Drag the fill handle to select C4:E4

5. Release the mouse button.

Release the mouse button

The label series appears in the selected cells and the Auto Fill Options button appears

Click any cell to deselect the range. Close but do not save SALES3.XLSX .

Page 94

OFFICEPRO, Inc.