no martin my question is that how can u fill the series of numbers from say
50 to 90 without using the fill paddle and that too from the middle of the
column

"MartinW" wrote:

Hi Neelakanta,

Maybe this is what you are looking for.

Type A25:A7000 in the name box and then tap enter,
(the range A25:A7000 will be highlighted)
Type 1 and tap enter,
(A25 will show 1 and A26 will become the active cell)
Then go to EditFillSeries set your options and tap OK

HTH
Martin


"Neelakanta" wrote in message
...
Thanks Sandy for replying soon. The things that u have described in the
privious post are familiar to me. The question is that without dragging
the
"Fill paddle" how can i easily fill the numbers.(e.g. if i need to drag
about
7000 numbers then it takes time. Isn't it? )in this case the easy thing is
that choose the entire column suppose "A" enter no. 1 and then go to
edit-
fill- series- here type the desired stop value and press enter. that's
it!
u will get the numbers until the specified stop value. But this works
only
if u select the entire row . i need this feature to be worked in the
middle
of the row also ........... can u help me please.........
Thanks in Advance.
Regards
Neelakanta

"Sandy Mann" wrote:

If you mean a series of numbers like 1, 2, 3, 4 etc then put 1 in the
first
cell, 2 in the second and highlight both and drag down or along as the
case
may be on the fill handle of the 2nd cell.

If you mean copy the formula in the first cell to a range then with a
formula - say =A1+B1 then simply drag down on the fill hande. The
formula
will index uplike:

=A1+B1
=A2+B2
=A3+B3

If you want one of the cells to remain constant - say in this example the
cell A1 then make it an absolute reference like:

=$A$1+B1
=$A$1+B2
=$A$1+B13

If this is not what you want then post back with more details for what
you
are trying to do.

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Neelakanta" wrote in message
...
Thank u for the quick reply. But can u also teach me how easily to fill
the
numbers in the columuns please.