View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default numbers in order

Type 101157 in a cell.

Right-click on the fill handle and drag down.

Release button and "Fill Series"


Gord Dibben MS Excel MVP

On Tue, 4 Dec 2007 04:44:00 -0800, woody
wrote:

I would like to know how i can do the following in excel?

101157
101158
101159 ect
Can this be done automatically when i drag the box down it will just do
101157 over and over please help