Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers in order
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers in order
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 Replace @mailinator.com with @tiscali.co.uk "woody" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers in order
Mike
Type in the 3 numbers manually then select all 3 cells and drag down on the fill handle of the lowest cell. Mike "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
numbers in order
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. "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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reverse order of numbers | Excel Discussion (Misc queries) | |||
getting numbers divisible by 4 from random numbers in ascending order | Excel Worksheet Functions | |||
Rearrange numbers from a column in a different order in a second c | Excel Discussion (Misc queries) | |||
Reverse order of numbers in a column | Excel Discussion (Misc queries) | |||
Sorting order - text and numbers | Excel Discussion (Misc queries) |