View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default how do i make values increase by 1 while going down a cell

Enter a number in A1.

Right-click and drag down.

Release button and "Fill Series"


Gord Dibben MS Excel MVP

On Wed, 14 Nov 2007 12:33:19 -0800, michelle
wrote:

I enter in numbers in a column and i want to drag the box down and have the
number increase by one from the previous number in each cell. HELP!