O'Reilly logo

Microsoft® Office Home and Student 2007 Step by Step by Joan Lambert, Curtis Frye, Joyce Cox

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required