numbers in order

W

woody

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
 
S

Sandy Mann

With 101157 in A1 and 101158 in A2, highlight both cells and drag down o the
fill handle

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
M

Mike H

Mike

Type in the 3 numbers manually then select all 3 cells and drag down on the
fill handle of the lowest cell.

Mike
 
S

Soundar

Hi,

Just type two number and then select them, and then drag the fill handler
(small box in the right bottom of the cell), untill the number you want.

Hope this will clear your doubt.

Regards,
Soundar.
 
G

Gord Dibben

Type 101157 in a cell.

Right-click on the fill handle and drag down.

Release button and "Fill Series"


Gord Dibben MS Excel MVP
 
Top