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.