One method.....there are many.

Enter 1 in A1.

Go to Name Box left of Formula Bar and type A1:A3000 then hit ENTER key.

EditFillSeriesLinearOK


Gord Dibben Excel MVP

On Wed, 20 Apr 2005 15:55:02 -0700, "toddb123"
wrote:

Is there a way to automatically list numbers? For example I want to make a
number list from 1-3000. If I enter 1 can Excel list the rest automatically?