Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto fill
I already have an exsisting sequence in a worksheet. I now need to
expand the sequence. When I pull down on the fill handle the sequence continues by 1's and not 10's as it should. Any suggestions. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto fill
Select the last two cells in your list before using the fill handle. Excel
should then recognize the pattern of increasing by 10 and autofill accordingly. -- Elisabeth " wrote: I already have an exsisting sequence in a worksheet. I now need to expand the sequence. When I pull down on the fill handle the sequence continues by 1's and not 10's as it should. Any suggestions. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto fill
Make sure you have at least 2 or 3 numbers of your sequence selected before
you use the pull-down. If you have 10, then drag, it will go by one. If you have 10 and 20 and 30 selected, then drag down, it will fill in tens. " wrote: I already have an exsisting sequence in a worksheet. I now need to expand the sequence. When I pull down on the fill handle the sequence continues by 1's and not 10's as it should. Any suggestions. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto fill
Assuming you have
ABC10 ABC20 ABC30 Select at least two of the cells before dragging. Gord Dibben MS Excel MVP On 16 Jan 2007 13:30:43 -0800, wrote: I already have an exsisting sequence in a worksheet. I now need to expand the sequence. When I pull down on the fill handle the sequence continues by 1's and not 10's as it should. Any suggestions. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto fill
Your example is the type of sequence that I have and I have done what
you suggested, but it still counts by ones's. Gord Dibben wrote: Assuming you have ABC10 ABC20 ABC30 Select at least two of the cells before dragging. Gord Dibben MS Excel MVP On 16 Jan 2007 13:30:43 -0800, wrote: I already have an exsisting sequence in a worksheet. I now need to expand the sequence. When I pull down on the fill handle the sequence continues by 1's and not 10's as it should. Any suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto fill option | New Users to Excel | |||
Macro for Auto Fill | Excel Discussion (Misc queries) | |||
stop auto fill from thinking for itself!!!!!!! | New Users to Excel | |||
Auto Fill Options | Excel Discussion (Misc queries) | |||
Auto Fill Options | Excel Discussion (Misc queries) |