Creating
a List or a Series using AutoFill |
The AutoFill function allows you to create a list or a series,
in addition to copying the contents of a cell across a row or down a column.
To create a list or a series, follow the instructions below.
- Enter the first option of your list or series in a cell, such as the word
Monday.
- Point the cursor to the lower right-hand corner of the cell until the cursor
changes from an arrow to a solid cross (+).
- Press down and hold down the left mouse button while dragging the mouse down
a column or across a row.
- The cells that you dragged the mouse through will now contain your new series
or list.
Note: For a numbered list, you have to enter 1 in
the first cell, 2 in the second cell, and then select both cells before
dragging. Otherwise, Excel assumes that you just want to copy the number 1.
Click HERE to return to the Table of Contents.