Microsoft® Office Home and Student 2007 Step by Step

6 Working with Data and Data Tables

To enter a data series using AutoFill

1. Type the first label or value for your list.

2. Drag the fill handle to the cell containing the last label or value in the series.

To change how dragging the fill handle extends a series

1. Type the first label or value for your list.

2. Hold down the key, and drag the fill handle to the cell containing the last label or value in the series.

To enter data by using AutoComplete

1. Type the beginning of an entry.

2. Press to accept the AutoComplete value.

To enter data by picking from a list

1. Right-click ...