Enter 1 in A1

Right-click on the fill handle and drag down as far as you wish.

Release button and "Fill Series"


Gord Dibben MS Excel MVP

On Wed, 23 Sep 2009 15:25:02 -0700, mike
wrote:

i need to know how to make a column of cells increase in number from 1 - what
ever so i dont have to keep going from cell dropdown to next cell and so on.