Working with Data and Data Tables
To enter a data series using AutoFill
Type the first label or value for your list.
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
Type the first label or value for your list.
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
Type the beginning of an entry.
Press to accept the AutoComplete value.
To enter data by picking from a list
Right-click ...
Get 2007 Microsoft® Office System Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.