Here are a few.

1. Enter 1 in A1. Right-click and drag down 12 rows. Release button and
"Fill Series"

2. Enter 1 in A1, 2 in A2. Select both and left-click drag down 12 rows.

3. Select A1:A12. In A1 type 1 then EditFillSeriesLinear. Enter a Step
Value if you wish.

4. For a unique fill series........ToolsOptionsCustom ListsNew. Type your
items in comma-delimited. Enter the first in A1 then left-click drag down.


Gord Dibben Excel MVP




On Wed, 14 Dec 2005 12:34:45 -0800, "D J R"
wrote:

Looking for the diiferent ways to fill series in excel